I have a DTS package stored in SQL 2005. It connects to a SQL cluster to process data weekly. I got lots of connection failure errors like below recently. Please help
Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The task reported failure on execution. (Microsoft OLE DB Provider for SQL Server (80004005): Connection failure) Step Error code: 8004043B Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100
You need to troubleshoot why the connection is failing. I would start by checking with your network administrator. Maybe you need to increase the connection timeout value if you have a slow network or slow servers.
I have check the network. It shows that there is a tcp reset from SQL server, plus this is 1GB network. I do not believe there are anything wrong with network. I have changed the timeout value on SQL to 6000 which is 100mins already...