SSIS Command Line Utilities

It performs Package Management tasks, such as Deployment through Command Line or Batch File  Processes.

It will work with packages that are stored in the File System or SQL Server or Designated folder in SSIS.DTUTIL can also set the encryption settings and digitally sign packages through command line scripts.By using DTUTIL Command Line Utility which can Move, Copy, Delete, Encrypt and Digitally sign packages.

DTUTIL Execution Method:

Can execute DTUTIL from any Command Line Utility including SQL SERVER Agent or Windows Scheduler. When you create DTUTIL through an automated Command Line Utility you can use table to interrupt or return codes.

• 0-Success
• 1-Failure
• 4-Package Not Found
• 5-Package can not load
• 6-Bad Syntax

DT EXEC UI:

This is used to run the  Integration  Services packages. it stores the package in one of these three locations. 

• Microsoft SQL Server
• SSIS Package Store
• File System

This user interface, which can be opened from SQL Server Management Studio or by typing dtexecui at a command prompt, is an alternative to running packages by using the DTExec command prompt tool.

The Execute Package Utility is a graphical user interface for the DTExec command prompt tool. The user interface makes it easy to configure options and it automatically assembles the command line that is passed to the DTExec command prompt tool when you run the package from the specified options.

The Execute Package Utility can also be used to assemble command lines that you use when running DTExec directly.

DT EXEC

The DT EXEC Command line Utility can reference and execute a package , giving you several parameters for controlling the execution. such as Changing Connection, setting logging operations and applying Configurations files. The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.