SSIS Environment Configuration using PowerShell

• Raxso1

  SSC Veteran

  Points: 272

  More actions

  October 3, 2019 at 11:24 am

  #3685621

  Hi

  I have a customer who have already deployed a number of SSIS packages, without environment variables setup.  Does anyone have a PowerShell script to just create the environment variables based on the SSIS package that already exist?

  Raxso1

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  October 3, 2019 at 11:53 am

  #3685632

  I'm pretty sure the answer will be no. As the contents of packages are encrypted inside SSISDB, there would be no way of interrogating them.

  ---