DTS Package

[bob120579]

Is it possible to run a DTS package from a stored procedure or from a command? If so, which command? I must be able to do it from a pass-through query or from query analyzer....Thanks

 

[NoCoolHandle]

Yes..

You need to do it via a call to dtsrun (and pass switches to it)

dtsrun is an exe and to run it you will need to use xp_Cmdshell


Search BOL (books on line) for dtsrun

 

[ftc128]

I've made a stored proc that calls dtsrun using the extended procedure. My problem is that when I call this proc from a web app, it stalls and doesn't execute. This doesn't happen when the web and SQL servers are the same machine, but it fails when they are separate. Anybody know how to remedy this? That is, how to get a stored proc, called by IIS on one server to execute on another server?

Thanks in advance