Integration Services Tables (Transact-SQL)

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.

    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.