Monday, July 10, 2006

DTS Package run from stored procedure sp

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 :

1 comment:

Anonymous said...

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 ;)