Export (0) Print
Expand All

Integration Services Tables (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

The topics in this section describe the system tables in the msdb database that store information used by SQL Server Integration Services.

In This Section

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.

System_CAPS_noteNote

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.

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

Community Additions

ADD
Show:
© 2015 Microsoft