Dogodek
Pridobite potrdilo v storitvi Microsoft Fabric – brezplačno!
19. nov., 23h - 10. dec., 23h
Za omejen čas ekipa Microsoft Fabric Community ponuja brezplačne kupone za izpit DP-600.
Pripravite se zdajTa brskalnik ni več podprt.
Izvedite nadgradnjo na Microsoft Edge, če želite izkoristiti vse prednosti najnovejših funkcij, varnostnih posodobitev in tehnične podpore.
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
Displays the details for all projects that appear in the SSISDB catalog.
Column name | Data type | Description |
---|---|---|
project_id | bigint | The unique identifier (ID) of the project. |
folder_id | bigint | The unique ID of the folder where the project resides. |
name | sysname | The name of the project. |
description | nvarchar(1024) | The optional description of the project. |
project_format_version | int | The version of SQL Server that was used to develop the project. |
deployed_by_sid | varbinary(85) | The security identifier (SID) of the user who installed the project. |
deployed_by_name | nvarchar(128) | The name of the user who installed the project. |
last_deployed_time | datetimeoffset(7) | The date and time at which the project was deployed or redeployed. |
created_time | datetimeoffset(7) | The date and time at which the project was created. |
object_version_lsn | bigint | The version of the project. This number is not guaranteed to be sequential. |
validation_status | char(1) | The validation status. |
last_validation_time | datetimeoffset(7) | The time of the last validation. |
This view displays a row for each project in the catalog.
This view requires one of the following permissions:
READ permission on the project
Membership to the ssis_admin database role
Membership to the sysadmin server role.
Opomba
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.
Dogodek
Pridobite potrdilo v storitvi Microsoft Fabric – brezplačno!
19. nov., 23h - 10. dec., 23h
Za omejen čas ekipa Microsoft Fabric Community ponuja brezplačne kupone za izpit DP-600.
Pripravite se zdaj