sysssispackages (Transact-SQL)

Article
2013-05-16

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 Integration Services format. A value of 3 indicates that the package is saved in the SQL Server 2008 Integration Services format.
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). 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.

See Also

Concepts

Integration Services (SSIS) Packages