Export (0) Print
Expand All

sysssispackages (Transact-SQL)

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

Applies to: SQL Server (SQL Server 2008 through current version).

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).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft