sysdtspackagefolders90 (Transact-SQL)

  • Article

Contains one row for each folder in the folder hierarchy that Microsoft SQL Server 2005 Integration Services (SSIS) 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 2005 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

nvarchar

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