SSIS中多有中方式可以查看Package发布的历史记录
1，通过Integration Services Catalogs来查看，打开SSISDB，Projects，查看指定project的properties
这种方式查看Deployment Date 比较慢
2，通过Integration Services Catalogs来查看，打开SSISDB，Projects，查看指定project的version history
这种方式查看Deployed Time 比较慢
3,查询SSISDB的表projects
select name as ProjectName,deployed_by_name,last_deployed_time from internal.projects where name=N‘xxx‘
4,通过查看SSISDB的表catalog.object_versions
select top 11 ov.object_version_lsn,ov.object_id,ov.object_type,ov.object_name,ov.created_by,ov.created_time from catalog.[object_versions] ov where ov.object_name=N‘xxx‘ order by ov.created_time desc
|
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. |
原文：http://www.cnblogs.com/ljhdo/p/4899086.html