Share via


sysdtspackages90 (Transact-SQL)

Contains one row for each package that is saved to Microsoft SQL Server 2005. 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 description of the package.

createdate

datetime

The date the package was created.

folderid

uniqueidentifier

The GUID of the 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 the package is saved to. All packages use the value 0. This indicates that the package is saved to an XML format.

packagetype

int

The client that created the package. The values are as follows: 0 (default client), 1 (SQL Server Import and Export Wizard), 2 (DTS Designer in SQL Server 2000), 3 (SQL Server Replication), 5 (SSIS Designer), and 6 (Maintenance Plan Designer).

vermajor

int

The latest major version of the package.

verminor

int

The latest minor version of the package.

verbuild

int

The version of Integration Services used to build the package.

vercomment

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.

readerrole

nvarchar

The SQL Server role that can load packages.

writerrole

nvarchar

The SQL Server role that can save packages.

See Also

Other Resources

Integration Services Packages

Help and Information

Getting SQL Server 2005 Assistance