Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sysssispackagefolders (Transact-SQL)


Applies To: SQL Server 2014, SQL Server 2016 Preview

Contains one row for each logical folder in the folder hierarchy that Microsoft SQL Server Integration Services uses. These folders are listed in Object Explorer of SQL Server Management Studio when you connect to Integration Services. A folder lists packages that are saved to SQL Server 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.

Applies to: SQL Server (SQL Server 2008 through current version).

Column name

Data type




The GUID of the folder.



The GUID of the folder that is the parent folder.



The name of the folder. This name appears in the folder hierarchy in SQL Server Management Studio.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft