Executing Powershell Script From SSIS

Question

I need to run a powershell script using SSIS "Execute Process Task"

What is the syntax for the Arguments line?  Right now I have the below.  I'm getting an error message with exit code 1.

powershell -noexit -command "C:\SaveAsCSV.ps1"

Answer 1

did you set full path for powershell?

these are examples of executing powershell script with Execute Process Task:

http://rjbook.wordpress.com/2009/07/15/powershell-and-ssis/

http://jingyangli.wordpress.com/2011/09/28/to-run-a-powershell-script-from-ssis-package/

---

http://www.rad.pasfu.com