segunda-feira, 30 de março de 2015

Verifica versão do dtsx SQL SERVER

Segue comandos para averiguar a versão publicada de SSIS (.dtsx)
OBS.: Substitui o PackageName pelo nome do pacote.

--------------------------------------------
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 ('PackageName')
order by CreateDate desc

0 comentários: