obtaining the package XML

• Barkstuff

  Say Hey Kid

  Points: 662

  More actions

  November 18, 2015 at 5:54 am

  #322679

  Hello, prior to 2012 I obtained the package xml via

  SELECT

  Name,

  CAST(CAST(CAST([packagedata] as varbinary(max)) as varchar(max)) as XML) as [XML]

  FROM [msdb].[dbo].[sysssispackages]

  However I am at a loss as to get the package XML when the package has been deployed to the SSISDB catalog.

  Anyone know how to get to it?

  Thanks B 🙂

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  November 18, 2015 at 6:16 am

  #1840626

  You can't, as far as I know. It's stored in encrypted form.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel