Export (0) Print
Expand All

catalog.packages (SSISDB Database)

Displays the details for all packages that appear in the SSISDB catalog.

Column name

Data type

Description

package_id

bigint

The unique identifier (ID) of the package.

name

nvarchar(256)

The unique name of the package.

package_guid

uniqueidentifier

The globally unique identifier (GUID) that identifies the package.

description

nvarchar(1024)

An optional description of the package.

package_format_version

int

The version of SQL Server that was used to develop the package.

version_major

int

The major version of the package.

version_minor

int

The minor version of the package.

version_build

int

The build version of the package.

version_comments

nvarchar(1024)

Optional comments on the version of the package.

version_guid

uniqueidentifier

The GUID that uniquely identifies the version of the package.

project_id

bigint

The unique ID of the project.

entry_point

bit

The value of 1 signifies that the package is meant to be started directly. The value of 0 signifies that the package is meant to be started by another package with the Execute Package task. The default value is 1.

validation_status

char(1)

The status of the validation.

last_validation_time

datetimeoffset(7)

The time of the last validation.

This view displays a row for each package in the catalog.

This view requires one of the following permissions:

  • READ permission on the corresponding project

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role.

Note Note

If you have READ permission on a project, you also have READ permission on all of the packages and environment references associated with that project. Row-level security is enforced; only rows that you have permission to view are displayed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft