catalog.packages (SSISDB Database)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
package_idbigintThe unique identifier (ID) of the package.
namenvarchar(256)The unique name of the package.
package_guiduniqueidentifierThe globally unique identifier (GUID) that identifies the package.
descriptionnvarchar(1024)An optional description of the package.
package_format_versionintThe version of SQL Server that was used to develop the package.
version_majorintThe major version of the package.
version_minorintThe minor version of the package.
version_buildintThe build version of the package.
version_commentsnvarchar(1024)Optional comments on the version of the package.
version_guiduniqueidentifierThe GUID that uniquely identifies the version of the package.
project_idbigintThe unique ID of the project.
entry_pointbitThe 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_statuschar(1)The status of the validation.
last_validation_timedatetimeoffset(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.

System_CAPS_ICON_note.jpg 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.

Community Additions

ADD
Show: