sysssispackages (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each package that is saved to Microsoft SQL Server. This table is stored in the msdb database.

Column name Data type Description
name sysname The unique identifier of the package.
id uniqueidentifier The GUID of the package.
description nvarchar The optional description of the package.
createdate datetime The date the package was created.
folderid uniqueidentifier The GUID of the logical folder in which SQL Server Management Studio lists the package.
ownersid varbinary The unique security identifier of the user who created the package.
packagedata image The package.
packageformat int The format in which the package is saved:

A value of 2 indicates that the package is saved in the SQL Server 2005 Integration Services format.

A value of 3 indicates that the package is saved in format of SQL Server 2008 Integration Servicesor later.
packagetype int The client that created the package. The possible values are as follows:

0 (default value)

1 ( SQL Server Import and Export Wizard)

3 ( SQL Server Replication)

5 ( SSIS Designer)

6 (Maintenance Plan Designer or Wizard).

Note that the values in this column correspond to the DTSPackageType enumeration.
vermajor int The latest major version of the package.
verminor int The latest minor version of the package.
verbuild int The latest build of the package.
vercomments nvarchar Comments about the package version.
verid uniqueidentifier The GUID of the package version.
isencrypted bit A Boolean that indicates whether the package is encrypted.
readrolesid varbinary The SQL Server role that can load packages.
writerolesid varbinary The SQL Server role that can save packages.

See Also

Integration Services (SSIS) Packages