Do you know how to execute DTS package in Store Procedure?
--
shooi

Look up DTSRUN

run it like this xp_cmdshell 'DTSRUN ............'

To get the complete DTSRUN syntax fom the DTS package, the easiest way is to
schedule the package, go to the job and copy the code from step 1 and then
delete the job

http://sqlservercode.blogspot.com/

"shooi" wrote:

In addition, if you need more flexibility than using dtsrun,
you can use the OLE automation stored procedures. You can
find a link to examples at:
http://www.sqldts.com/default.aspx?210

-Sue

On Thu, 6 Oct 2005 01:11:07 -0700, "shooi"
<shooi (AT) discussions (DOT) microsoft.com> wrote: