quarta-feira, 11 de fevereiro de 2015

Verificando a versão do DTSX do Sql server importado



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