Home Forums Data Warehousing Integration Services How to execute a powershell script in Execute Process Task RE: How to execute a powershell script in Execute Process Task

  • July 22, 2016 at 9:40 am

    #1891619

    dndaughtery (7/22/2016)

    I changed the executable to C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe in the process tab of the execute process task and now getting a different error:

    "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "-ExecutionPolicy Unrestricted -File"\\MyServer\Myfolder\FolderA\Powershell_Scripts\Get-Files.ps1"" at "", The process exit code was "1" while the expected was "0".

    Try running this in a .bat file, outside of SSIS. You may get better error messages.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.