sysssispackages (Transact-SQL)

 

Updated: June 10, 2016

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 nameData typeDescription
namesysnameThe unique identifier of the package.
iduniqueidentifierThe GUID of the package.
descriptionnvarcharThe optional description of the package.
createdatedatetimeThe date the package was created.
folderiduniqueidentifierThe GUID of the logical folder in which SQL Server Management Studio lists the package.
ownersidvarbinaryThe unique security identifier of the user who created the package.
packagedataimageThe package.
packageformatintThe 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 2008Integration Servicesor later.
packagetypeintThe 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.
vermajorintThe latest major version of the package.
verminorintThe latest minor version of the package.
verbuildintThe latest build of the package.
vercommentsnvarcharComments about the package version.
veriduniqueidentifierThe GUID of the package version.
isencryptedbitA Boolean that indicates whether the package is encrypted.
readrolesidvarbinaryThe SQL Server role that can load packages.
writerolesidvarbinaryThe SQL Server role that can save packages.

Integration Services (SSIS) Packages

Community Additions

ADD
Show: