sysssispackages (Transact-SQL)

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 the SQL Server 2008 Integration Services format. 

packagetype

int

The client that created the package. The possible values are as follows:

  • 0 (default value)

  • 1 (SQL Server Import and Export Wizard)

  • 2 (DTS Designer in SQL Server 2000)

  • 3 (SQL Server Replication)

  • 5 (SSIS Designer)

  • 6 (Maintenance Plan Designer or Wizard).

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

Concepts