catalog.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. |
Remarks
This view displays a row for each package in the catalog.
Permissions
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
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.
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho