Integration Services Tables (Transact-SQL)
SQL Server 2012
The topics in this section describe the system tables in the msdb database that store information used by SQL Server Integration Services.
- sysssislog
-
Contains one row for each log entry that an Integration Services package generates at run time.
This table is used only when packages use the SQL Server log provider.
- sysssispackagefolders
-
Contains one row for each logical folder that the Integration Services service uses to organize packages. Column values define the parent/child relationships between nested folders.
Note
Management Studio displays stored packages in a hierarchical view when you connect to the Integration Services service.
- sysssispackages
-
Contains one row for each Integration Services package.
This table is used only when you store packages in SQL Server.
