Run a 32 bit Powershell script on Sql Server Agent

Question

I have a powershell script that runs a 32 bit com object so when I run it in Powershell 64x it fails but runs fine in 86x

When I run it in a Sql Server Agent job it has the same 64x failure.

Is there a way around this? Like SSIS packages?

I ended up running CmdExec bat file that ran 32 Powershell file but I'm open to other ideas — Chris Hayes, Apr 20 '12 at 21:12

score 4 · Accepted Answer · answered Apr 21 '12 at 03:06

4

You can directly invoke the 32-bit version of PowerShell by calling it through the WOW64 path:

%SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe

Using the -File command line argument you can pass the name of the script you would like to run.

answered Apr 21 '12 at 03:06

Goyuix

1 Answers1