- Change the SSIS package to run as 32bit
- Import the SSIS package as a file system deployment
- Create a credential on the SQL server
- Create a Proxy for the above credential for the cmd.exec
- Create a sql agent job to use a Operating System (Cmd Exec) in the job step
- Set the SQL agent to use the proxy account that was created above
- Now here's the part that forces it to use the 32bit - Set the job step to call the 32bit version of the dtexec.exe (i.e. "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /f "[package file location and name]")
I hope this helps others as this is was a godsend for me
No comments:
Post a Comment