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:
|
packagetype |
int |
The client that created the package. The possible values are as follows:
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. |