Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
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: A value of 2 indicates that the package is saved in the SQL Server 2005 (9.x) Integration Services format. A value of 3 indicates that the package is saved in format of SQL Server 2008 (10.0.x) Integration Servicesor later. |
| packagetype | int | The client that created the package. The possible values are as follows: 0 (default value) 1 (SQL Server Import and Export Wizard) 3 (SQL Server Replication) 5 (SSIS Designer) 6 (Maintenance Plan Designer or Wizard). Note that 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. |