| title | sysssispackages (Transact-SQL) | ||
|---|---|---|---|
| description | sysssispackages (Transact-SQL) | ||
| author | lrtoyou1223 | ||
| ms.author | lle | ||
| ms.date | 06/10/2016 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Contains one row for each package that is saved to [!INCLUDEmsCoName] [!INCLUDEssNoVersion]. 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 [!INCLUDEssManStudioFull] 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 [!INCLUDEssVersion2005] [!INCLUDEssISnoversion] format. A value of 3 indicates that the package is saved in format of [!INCLUDEsql2008-md] [!INCLUDEssISnoversion] or later. |
| packagetype | int | The client that created the package. The possible values are as follows: 0 (default value) 1 ([!INCLUDEssNoVersion] Import and Export Wizard) 3 ([!INCLUDEssNoVersion] Replication) 5 ([!INCLUDEssIS] Designer) 6 (Maintenance Plan Designer or Wizard). Note that the values in this column correspond to the xref:Microsoft.SqlServer.Dts.Runtime.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 [!INCLUDEssNoVersion] role that can load packages. |
| writerolesid | varbinary | The [!INCLUDEssNoVersion] role that can save packages. |