Execute process task SSIS

• mikesql710

  Old Hand

  Points: 342

  More actions

  November 6, 2020 at 5:09 am

  #3804848

  Hi Guys,

  I need urgent help. I have a Powershell script that I am executing through "Execute Process Task," and the return is two variables values. I can capture one variable to use a variable in "Standard Output Variable.". I would like to know how I can capture the second return value from the Powershell script.

  I can combine two outputs in the Powershell script and use "Standard Output Variable." and use "Derived column Transf" to split in two, but I am sure it must be a way to use two outputs variable.

  Please advise.

  Thanks!

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  November 7, 2020 at 5:10 am

  #3805176

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• mikesql710

  Old Hand

  Points: 342

  More actions

  November 7, 2020 at 6:43 pm

  #3805521

  Any advice?