Evenementer
Mar 31, 11 PM - Apr 2, 11 PM
Dat gréisst Léier-Evenement fir SQL, Fabric a Power BI. 31. Mäerz - 2. Abrëll. Benotzt de Code FABINSIDER, fir $400 ze spueren.
Mellt Iech haut uncatalog.packages (SSISDB Database)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
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.
Notiz
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.