Export (0) Print
Expand All

catalog.object_versions (SSISDB Database)

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 20 will be displayed for projects.

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.

Note Note

Row-level security is enforced; only rows that you have permission to view are displayed.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft