Author Posts

June 11, 2018 at 3:24 pm

Hi, I am trying to run powershell script in SSIS package, but its failing to run the script. The scripts runs fine when run as administrator on powershell but fails when run on cmd or in ssis.

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

When I change "-file" to "command" ssis package runs but does't get the right data from api . I have checked it with various execution policy and I can't change server settings.

Arguments :--  -NoProfile -ExecutionPolicy Bypass  -file C:\Users\random.ps1 -oauth_consumer_key "random" -oauth_consumer_secret "random" -oauth_token "random" -oauth_token_secret "random" -url "random" -location "random".json 

June 11, 2018 at 5:22 pm

It probably isn't execution policy; you probably need to configure SSIS to run the command under different credentials. Alternately, you might not be passing the right parameters, but not knowing anything about the API I can't really begin to guess. If it works when you run it from the console, then you're probably not having a PowerShell problem – it's much more likely something in the way SSIS needs to work, but I can't help there.