SQL Server: command line support

[nzanella]

Hello,

I would like to know whether it is possible to execute DTS
(Data Transformation Services) packages created from within
the EM (Enterprise Manager) user interface, from the command
line. That is, is it possible to execute a command at the DOS
prompt which will execute, and optionally also reconfigure,
the DTS package? This would allow invoking DTS packages
from within scripts.

Thank you for your replies,

Neil

[David Portas]

Yes. Read about the DTSRUN utility in Books Online.

--
David Portas
SQL Server MVP
--

[Simon Hayes]

Yes - see "DTS Package Execution Utilities" and "dtsrun Utility" in
Books Online. You can pass values to global variables from the command
line, if that's what you mean by "reconfigure". Also see here:

http://www.sqldts.com/default.aspx?301

Simon