Verifica versão do dtsx - 2005
SELECT PACK.name AS PackageName
,PACK.isencrypted AS IsEncrypted
,PACK.createdate AS CreateDate
,CONVERT(varchar(10), vermajor)
+ '.' + CONVERT(varchar(10), verminor)
+ '.' + CONVERT(varchar(10), verbuild) AS Version
,DATALENGTH(PACK.packagedata) AS PackageSize
FROM msdb.dbo.sysdtspackages90 AS PACK
where PACK.name in ('PackageName')
order by CreateDate desc
Verifica versão do dtsx - 2008
SELECT PACK.name AS PackageName
,PACK.isencrypted AS IsEncrypted
,PACK.createdate AS CreateDate
,CONVERT(varchar(10), vermajor)
+ '.' + CONVERT(varchar(10), verminor)
+ '.' + CONVERT(varchar(10), verbuild) AS Version
,DATALENGTH(PACK.packagedata) AS PackageSize
FROM msdb.dbo.sysssispackages AS PACK
where PACK.name in ('PLDAdviceCargaMovFinanceiro')
order by CreateDate desc
0 comentários:
Postar um comentário