How to Execute SSIS Package from Command Line in 32 Bit runtime and 64 bit runtime - SSIS Tutorial

Executing SSIS Package from Command Line is easy. You will be using DTExec.exe. You have two choices, either to execute your SSIS Package in 32bit runtime or 64bit runtime.

To execute your SSIS Package in 32bit runtime

Go to Run, type cmd to open the command line.to execute SSIS Package in 32 bit runtime, use below.

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

Notice, I am using 150 folder in above as I have SQL Server 2019. You will change that according to your SQL Server.

In below example I am running my ssis package in 32 bit.

"C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\DTExec.exe" /f "C:\Users\Aamir.Shahzad\Source\Repos\SSIS2\Integration Services Project1\Integration Services Project1\Package.dtsx"

This is how your output in cmd will look like.

To run your SSIS package in 64bit runtime.

 You can use the below command.

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

In the below example, I am executing Package.dtsx SSIS Package from the command line.

"C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTExec.exe" /f "C:\Users\Aamir.Shahzad\Source\Repos\SSIS2\Integration Services Project1\Integration Services Project1\Package.dtsx"