SSISDB：查看SSIS Package 部署的历史记录

    

1，通过Integration Services Catalogs来查看

打开SSISDB-》Projects，查看指定project的version history，这种方式查看Deployed Time 比较慢

2,查询SSISDB的表projects，查看最后一次部署的时间

select
    f.name as foler_name, 
    --p.project_id,
    p.name as project_name,
    p.deployed_by_name,
    p.last_deployed_timefrom catalog.projects pinner join catalog.folders f    on p.folder_id=f.folder_id

3，通过查看SSISDB的表catalog.object_versions

--object type: 20 projectselect 
    f.name as foler_name, 
    p.project_id,
    p.name as project_name,
    ov.created_by as deployed_by,
    ov.created_time as deployed_atfrom catalog.object_versions ov 
inner join catalog.projects p 
    on ov.object_id=p.project_idinner join catalog.folders f 
    on p.folder_id=f.folder_idwhere ov.object_type=20
    and p.project_id=8order by deployed_at desc

转载于:https://blog.51cto.com/hzz333/1919087