Displays the versions of objects in the Integration Services catalog. In this release, only versions of projects are supported in this view.
|Column name||Data type||Description|
|object_version_lsn||bigint||The unique identifier (ID) of the object version. This number is not guaranteed to be sequential.|
|object_id||bigint||The unique ID of the object.|
|object_type||smallint||The type of object. A value of
|object_name||sysname(nvarchar(128))||The name of the object.|
|description||nvarchar(1024)||The description of the project.|
|created_by||nvarchar(128)||The name of the user who added the object to the catalog.|
|created_time||datetimeoffset||The date and time at which the object was added to the catalog.|
|restored_by||nvarchar(128)||The name of the user who restored the object.|
|last_restored_time||datetimeoffset||The date and time at which the object was last restored.|
This view displays a row for each version of an object in the catalog.
To see rows in this view, you must have one of the following permissions:
READ permission on the object
Membership to the ssis_admin database role
Membership in the sysadmin server role.
Row-level security is enforced; only rows that you have permission to view are displayed.