powershell and execute process task

• KoldCoffee

  SSCoach

  Points: 18971

  More actions

  January 26, 2015 at 4:34 pm

  #294740

  Want to use Execute Process Task Editor to execute powershell commands saved to a command file (attached).

  Executable:

  C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe

  Arguments:

  powershell C:\temp\ExcelToCSV.ps1 'C:\DWTestUploads\Marriot\Marriot_Room_Pricing_20150126.csv' 'C:\DWDataExtracts\Marriot\'

  Execute Process Task 'likes' everything and when I run the task goes green but SSIS really does not convert the Marriot_Room_Pricing csv to Excel and move it to new folder.

  I am able to run the powershell command directly from command like as follows and it works as desired:

  powershell C:\temp\ExcelToCSV.ps1 'C:\EDWTestUploads\Marriot\Marriot_Room_Pricing_20150126.csv' 'C:\DWDataExtracts\Marriot\'

  What tweaks do I need to make so that it actually works in SSIS?

• KoldCoffee

  SSCoach

  Points: 18971

  More actions

  January 26, 2015 at 6:41 pm

  #1773278

  removed 'powershell' from the beginning of the argument was solution