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