Thank this author by sharing:
By Jon Winer,
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...
Scheduling a SSIS package
No Results from a Scheduled job/package
Next in his series on Query Analyzer, Yakov Shlafman brings us a few ways that we can save more keys...
Scheduling SSIS package
can't schedule SSIS package