Post reply

Execute process task SSIS

  • 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!

     

  • 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.

  • November 7, 2020 at 6:43 pm

    #3805521

    Any advice?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply