integration-services-tables-transact-sql.md

title	Integration Services Tables (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	SQL Server Integration Services system tables system tables [SQL Server], Integration Services system tables [Integration Services] SSIS, system tables
ms.assetid	683b181b-0091-4a9c-86db-bc577af43cec
author	lrtoyou1223
ms.author	lle

Integration Services Tables (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

The topics in this section describe the system tables in the msdb database that store information used by [!INCLUDEssNoVersion] [!INCLUDEssISnoversion].

In This Section

sysssislog
Contains one row for each log entry that an [!INCLUDEssISnoversion] package generates at run time.

This table is used only when packages use the [!INCLUDEssNoVersion] log provider.

sysssispackagefolders
Contains one row for each logical folder that the [!INCLUDEssISnoversion] service uses to organize packages. Column values define the parent/child relationships between nested folders.

Note

[!INCLUDEssManStudio] displays stored packages in a hierarchical view when you connect to the [!INCLUDEssISnoversion] service.

sysssispackages
Contains one row for each [!INCLUDEssISnoversion] package.

This table is used only when you store packages in [!INCLUDEssNoVersion].