SQL Server Integration Services: Difference between revisions

Revision as of 04:49, 19 October 2012

Revision as of 04:53, 19 October 2012

Line 55:

DTEXEC executes a package from the command line wherever it may be stored. Before running the package, the tool may be instructed to apply configuration information, which will allow the same package to be reused with slightly different parameters, including different connection strings for its endpoints.

DTUTIL provides the ability to manage packages, again from the [[command prompt]]. The tool can copy or move a package from a file into the server store, or back out again. Among a few other sundry functions, it can be used to delete, rename, encrypt, or decrypt packages.

==Extensibility and programmability==