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
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.