One thing that maybe happening is that network transactions are disabled in server 2003, and must be explicitly enabled.  Take a look at this article and verify the settings are...

Alternatively, you can write a Custom DTS task in any managed code as long as its made available for interop.  You can write a completely custom task in managed code...

The link above is good.  I used it to get things working, just use regasm.exe to register the dll's on the production box.  That should get it working.

Well, there is two ways to approach this:  1.  Create a COM wrapper that .net can call.  That way you could use your existing code without rewriting it to managed...

ok, here it is: Its not perfect, but it works.

This is part of my code, so let me explain.  The important stuff is highlighted.  You have to get a hold of...

I assume you're binding the grid to a dataTable.  The datagrid does not contain any built in methods to output its contents to any file or stream.  The only format...

I don't have a firm solution for you for the 20 different files.  However, I would probably look at creating a loop within an activeX script to execute a data...

Although I haven't tried the merge replication through dial up yet, I have the same goal in mind.  There is a little bit about optimizing the merge replication in the...