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
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.
You must be logged in to reply to this topic.