DTS produces no data when called from network server
Posted on 2006-03-21
I have created a VB program that executes a several DTS packages on our SQL Server. This works fine when I run the program from my desktop (it takes about a minute to run) but when I run it on a network server, one of the DTS packages does not move any data from the source table to the target. It appears to execute this DTS package (i.e., when I step through the code in VB the DTS.Execute step runs and no errors seem to occur), but instead of running for a minute or so, it returns instantly.
I am running the same program on my desktop and on the server, and the other configuration elements appear to be in sync. I also ran the program from a colleague's desktop and it works fine there. It seems as though the only difference is that I am calling the DTS from a network server instead of from my desktop.
This program was previously working correctly on the server. The only thing that has changed is the IP address of the source data system (DB2 on AS/400). I modified the connection in the DTS package accordingly.
Does anyone have any idea what's going on here? I'm running out of stones to turn over.