| title | sysssispackagefolders (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | ddc4833f-27bf-4610-b739-d257961d17ac | ||
| author | lrtoyou1223 | ||
| ms.author | lle |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Contains one row for each logical folder in the folder hierarchy that [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssISnoversion] uses. These folders are listed in Object Explorer of [!INCLUDEssManStudioFull] when you connect to [!INCLUDEssISnoversion]. A folder lists packages that are saved to [!INCLUDEssNoVersion] or to the file system.
The parentfolderid column describes the folder hierarchy. The folder at the top of the folder hierarchy contains a null value in parentfolderid.
The foldername column contains the name of folders that appear in Object Explorer.
This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| folderid | uniqueidentifier | The GUID of the folder. |
| parentfolderid | uniqueidentifier | The GUID of the folder that is the parent folder. |
| foldername | sysname | The name of the folder. This name appears in the folder hierarchy in [!INCLUDEssManStudioFull]. |