21 Apr

SSIS: DTEXEC, DTEXECUI and DTUTIL

DTEXEC

DTEXEC is a command line utility that allows you to configure and execute SISS packages.  It provides access to all package and execution options.

You can load packages from the following sources:

  • Integration Services server
  • .ispac project file
  • SQL Server database
  • SSIS Package Store
  • File system

You can use DTEXEC to run a package created in earlier versions, which are temporarily upgraded, but you cannot permanently save those packages.

64-bit vs 32-bit

On a 64-bit computer, the 64-bit version of DTEXEC is installed.  If you want to use the 32-bit version you will need to install it.

When both are installed SSIS will attempt to run 32-bit version because the directory appears in the PATH variable.  SQL Agent, however, will run the 64-bit version.

You can run DTEXEC from the xp_cmdshell

/SET allows you to set package variables and properties.

/isserver sets the package path.

http://msdn.microsoft.com/en-us/library/hh231187.aspx

DTEXECUI

Allows you to run SSIS packages in a graphical interface.

You can run packages in one of the following locations

  • SQL Server
  • SSIS Package Store
  • File system

It is a 32-bit utility.

There are so many things in this tool that I’m not even going to try to list them.  I hope, that the two things I’ve listed above are enough.

http://msdn.microsoft.com/en-us/library/ms180378.aspx

DTUTIL

This utility is used to copy, move, delete or verify a package in any of the following locations:

  • SQL Server
  • SSIS Package Store
  • File system

On a 64-bit computer, the 64-bit version of DTUTIL is insntalled.  If you need the 32-bit version you will need to install it.  By default, if both are installed, the 32-bit version will run.

http://msdn.microsoft.com/en-us/library/ms162820.aspx

The following table might help for comparison purposes as well.

 DTEXECDTEXECUIDTUTIL
Overview:Allows you to configure and execute packages.A graphical UI for running packages.Allows you to copy, move, delete or verify a package.
Runs from:Command prompt.Command prompt or SSMS.Command prompt
Usable for packages store in:Integration Services server
.ispac project file
SQL Server database
SSIS Package Store
File system
SQL Server
SSIS Package Store
File system
SQL Server
SSIS Package Store
File system
32-bit vs 64-bitOn a 64-bit computer, the 64-bit version is installed. If both are installed, then the 32-bit will be the default. SQL Agent will run the 64-bit version.32-bit.On a 64-bit computer, the 64-bit version is installed. If both are installed, then the 32-bit will be the default.