|Can you run a DTS Package in Query Analyzer?...You sure can!|
The approach to running a DTS Package in Query Analyzer is not intuitive,
but it is elegant. Query Analyzer uses T-SQL and DTS uses COM, so at first glance you would not think
it was possible.
I actually have had a need to accomplish this and I have read several postings in discussion groups
inquiring about this same dilemma.
Here are the steps...
|1) Create your DTS Package|
|2) Schedule the DTS Package.|
|3) Edit the newly created job and delete the schedule.|
|4) Now you have an unscheduled job that is ready to be run from within Query Analyzer.|
|5) Execute the stored procedure|
passing in either the GUID of the job or the job's name from Query Analyzer.