Execute a powershell script using BODS?

Hi all,

Have created a script using PowerShell called script_unzip.ps1.

Can anyone pls help with the syntax to execute this in a BODS script.

I picture we have to use the exec() function, and I tried the below however it doesn't work. At times the job starts and gets stuck.

exec('cmd', '"C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe" "\\path_path_path\script_unzip.ps1" -wait', 8);

All help will be appreciated.

Thank you.

-Sid