Package Execution Utilities
The dtswiz utility starts the DTS Import/Export Wizard by using command prompt options. It's great for initiating the wizard from within other tools.
The dtsrun utility runs a DTS Package from a command prompt.
Usage: dtsrun /option [value] [/option [value]] …
Options ('/?' shows the complete option list; '-' May be substituted for '/'):
The package retrieval options include the following:
| /~S | Server name |
| /~U | Username |
| /~P | Password |
| /~E | Use trusted connection instead of /U /P |
| /~ /~M | Package password |
| /~G | Package Guid string |
| /~V | Package version Guid string |
| /~F | Structured storage UNC filename (overwritten if /S is also specified) |
| /~R | Repository database name (uses default if blank; loads package from repository database) ... |
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
