MartyConnelly
martyconnelly at shaw.ca
Sat Jan 17 12:19:27 CST 2004
Have a look around here http://www.sqlservercentral.com/default.asp To do it in VB http://www.sqldts.com/default.aspx?6,104,208,7,1 and Using SQL Server DTS with Visual Basic: Resources and Known Issues Most of these are getting around multi threading not available in VB http://www.sqldts.com/default.aspx?258 One major consideration to take into account when executing DTS from a client machine is that, such as you would be doing when running your application on your machine is that where the package executes, under the security context of the logged on user. This means any file paths must be accessible, and any data transferred will go through your machine. DTS is not a server side process. So check your clients will have access to required dll's as well. Ron Allen wrote: >Is it possible to execute a SQL Server 2000 DTS package from an >external program, such as one written in C#? If so, any pointers in >the right direction on how to do it? The C# program can have admin >permissions if needed. > >I've looked at BOL and Googled a bit and don't see anything... > >Thanks, > >Ron > >_______________________________________________ >dba-SQLServer mailing list >dba-SQLServer at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >http://www.databaseadvisors.com > > > > -- Marty Connelly Victoria, B.C. Canada