var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Run DTS from query
How can I run a DTS from a query?
I'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