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...

• A DTS package can be made in several ways. From within Enterprise Manager, click on Data Transformation

  Services, Local Packages, then New Package. Another option would be to right click on a table, click on All Tasks, then either

  Import or Export Data. When asked, save as a DTS package.

• This can be done either during the creation of the package or after it is complete.

• Drill down from Management to Jobs and find the job that now appears. Right click on the job and

  click on Properties. Click on the Schedule tab and delete the schedule.

sp_start_job,

passing in either the GUID of the job or the job's name from Query Analyzer.

Voila!