1 out of 1 rated this helpful - Rate this topic

sysssispackages (Transact-SQL)

SQL Server 2008 R2

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) 2 (DTS Designer in SQL Server 2000) 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.

Concepts

Integration Services Packages

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD