Microsoft SQL Server forum - SQL Server: command line support

Author

SQL Server: command line support

nzanella@cs.mun.ca

2005-03-30, 9:41 am

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

2005-03-30, 9:41 am

Yes. Read about the DTSRUN utility in Books Online.

--
David Portas
SQL Server MVP
--

Simon Hayes

2005-03-30, 9:41 am

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

Sponsored Links