Well, it works fine for me using an IP address as the server name, it picks up and executes the DTS package on our hosted server...

Not in the tables affected.  These only contain information for display.  The other tables which may be updated on the 'Live' server, would remain unaffected and the batch process which...

Phil

Basically the admin system makes changes to the local database (inserts, updates and deletes).  Then when they are happy they will commit these changes to the live database.  Now all...

OK Its Easy!

Add a reference to the COM Object 'Microsoft DTSPackage Object Library'.

DLL = C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll

Import this into your class in .NET :

Imports DTS

Then create the code to...

You can do it from ASP so I assume the same is true of .NET.  I am investigating this myself today, but to help you out the DTS package object...