To run DTS from stored procedureyou need to use the following code:
EXEC master..xp_cmdshell 'DTSRun /S "(local)" /U "sa" /P "password" /N "IPF Client Package Upload" /G "{8A50D656-0BA7-4687-AA24-71DA4FD35039}" /W "0"'
To get the DTSRun command line generated use the dtsrunui utility
for more info on dtsrunui utility :
http://www.sqldts.com/default.aspx?301
Subscribe to:
Post Comments (Atom)
1 comment:
i without a doubt adore your writing way, very unique.
don't give up as well as keep writing in all honesty , because it just simply worth to follow it,
excited to look into more and more of your own well written articles, kind regards ;)
Post a Comment