Use the below sql script we can find the package and version
details which is deployed in the SSIS server. I means we will get the history
of the deploy package.
SELECT fld.Name as FolderName
,fld.created_By_Name as folderCreatdBy
,fld.Created_time as folderCreateddate
,proj.name projectName
,proj.created_time
,proj.last_deployed_time
,proj.deployed_by_name
,proj.folder_id
,pkg.[project_version_lsn]
,pkg.[name] as Pakagename
,pkg.[description]
,pkg.[package_format_version]
,pkg.[version_major]
,pkg.[version_minor]
,pkg.[version_build]
,pkg.[version_comments]
FROM [SSISDB].[internal].folders fld
INNER join [SSISDB].[internal].[projects] proj
on proj.folder_id=fld.folder_id
INNER join [SSISDB].[internal].[packages] pkg
on pkg.project_id=pkg.project_id
|
See the Output
