| title | sysssispackages (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 66155dcd-dcdb-4e33-a242-1625828ad8d2 | ||
| author | lrtoyou1223 | ||
| ms.author | lle |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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 [!INCLUDEssKatmai][!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. |