[dba-SQLServer]Running DTS Package from external program?

Thank you Marty. I posted that message as my last work-related act
before the weekend, and now my reply to you is the first work-related
act of a new week.

In the morning, I'll start wading through these sites. They look pretty
helpful to me.

Thanks,

Ron


Saturday, January 17, 2004, 12:19:27 PM, you wrote:

M> Have a look around here
M> http://www.sqlservercentral.com/default.asp
M> To do it in VB
M> http://www.sqldts.com/default.aspx?6,104,208,7,1
M> and
M> Using SQL Server DTS with Visual Basic: Resources and Known Issues
M> Most of these are getting around multi threading not available in VB

M> http://www.sqldts.com/default.aspx?258

M> One major consideration to take into account when executing DTS from a
M> client machine is that, such as you would be doing when running your
M> application on your machine is that  where the package executes, under
M> the security context of the logged on user. This means any file paths
M> must be accessible, and any data transferred will go through your
M> machine. DTS is not a server side process. So check your clients will 
M> have access
M> to required dll's as well.