Run SSIS Package in 32 bit mode using bat file - SSIS Tutorial

 Often we need to situation where we want to create batch file to execute our SSIS Pacakage. I have seen this in many situation. One of example, sometime people use third party schedulers for which they create batch file for ssis package and then call that batch file in third party schedule. 

In this post, we are going to learn how you can create batch file for your SSIS Package execution in 32 bit mode.

1) First of all you are going to create an empty text file and change the extension to .bat.

If you don't know how to create batch file you can watch "How to create batch file"

2) Right click on batch file and then hit Edit. Paste below line of code to run your SSIS Package in 32 bit from batch file.

"C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\DTExec.exe" /f "Your SSIS Package Path"

Notice that, I have 150 folder because I am using SQL Server 2019. In your case you might 130,140 or 150 depending upon your SQL Server version.

I used below command in batch file to execute my Package.dtsx.

Save the file. Double click on it or call it from some scheduler and it should execute your SSIS Package in 32 bit.

No comments:

Post a Comment