| title | sysssispackagefolders (Transact-SQL) | ||
|---|---|---|---|
| description | sysssispackagefolders (Transact-SQL) | ||
| author | lrtoyou1223 | ||
| ms.author | lle | ||
| ms.date | 06/10/2016 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
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]. |