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