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.