Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |