Mini Post: DTEXEC.exe

Hey everyone! Welcome back to SQL Something!

Let's see if we can get a couple posts in on the last day of the month.

In the next few posts we're gonna take a brief look at some of the command prompt utilities that get installed when you install Integrated Services (IS). These utilities are 32-bit unless you also install Client Tools or Data Tools.

The first of which is DTEXEC.exe.

DTEXEC.exe is a command prompt utility that is used to configure and execute SSIS packages.

Configure:

• It let's you load packages from SQL Server, A SSIS package store and the File System.
• It let's you access package configurations which include: Parameters, Variables, Properties and Logging.

Execution:

Actual execution is done by calling three stored procedures.

• CATALOG.CREATE_EXECUTION - Creates an instance of execution in the SSIS catalog.
• CATALOG.SET_EXECUTION_PARAMETER_VALUE - Sets parameter values.
• CATALOG.START_EXECUTION - Starts an instance of execution.

You can view examples of syntax here.

DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)