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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment