How to run Powershell in SSIS using excute process task with variable?

Question

I have a SSIS package and I need to run Powershell to get some data. I used an Excute Process Task in SSIS and put C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe in executable and it works perfectly. Now I want to set up a variable to get the work done. I created a variable and put the datatype strin and set the value as C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe.

Then I went to expressions in the Executable Process task and make it 'executable' and put @[User::Powershell_Location] there. But I don't know what should I put in the Executable in process menu.

what is driving the decision to use PowerShell to get data rather the SSIS tools themselves? — PseudoToad
– PseudoToad, Commented Sep 25, 2015 at 18:28

Kay Khan · Accepted Answer · 2015-11-04 01:59:14Z

1

You need to go to the expression tab of Execute Process Task Editor and then assign an expression to 'Executable' and optionally to 'Arguments', if you have any arguments to pass in. See attached

answered Nov 4, 2015 at 1:59

Kay Khan

1861 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to run Powershell in SSIS using excute process task with variable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related