470,604 Members | 2,014 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,604 developers. It's quick & easy.

SQL Server: command line support


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

Jul 23 '05 #1
2 1171
Yes. Read about the DTSRUN utility in Books Online.

--
David Portas
SQL Server MVP
--

Jul 23 '05 #2
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

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by jas | last post: by
2 posts views Thread by george r smith | last post: by
5 posts views Thread by Chris Ochs | last post: by
2 posts views Thread by =?Utf-8?B?UmFtb24gR2VuZQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.