Run DTS from query

Hi ya!
How can I run a DTS from a query?
Thanks!
KenI'm not sure if this would work, but it might...

I don't think you can directly run a DTS package from the Query Analyzer...

But what you could do is use the Query Analyzer to create a job which executes the DTS package and then deletes the job it created...

Schedule a Package, then go to jobs and do a "generate script" and that should give you an idea of what the SQL should look like...

If you want to go this way and need help let me know, I haven't done it but I wouldn't mind playing around with the idea...|||exec master..xp_cmdshell 'dtsrun ...'

You can also use sp_oa... see
http://www.nigelrivett.net/sp_oacreateLoadDTSpackage.html