SQL Server 2000 Enterprise Manager no longer displays DTS packages and the SQL Server Agent jobs that use the DTS packages now fail.
The affected servers are running Windows Server 2003 SP2 and SQL Server 2000 SP4 and all update patches for both the OS and SQL Server.
The DTS packages are ActiveX scripts that read data from a database table and output that data to a text file on the same server. They include the database connection string and the SQL account used by the connection string has not changed.
I've determined that the DTS packages still exist by trying to re-create them with the same name, but they don't appear in the Local Packages window and they no longer function when the scheduled job that uses then runs.
The SQL Server Agent Job error is as follows:
Executed as user: <server admin user account>. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 11 (B) Error string: [DBNETLIB][ConnectionRead (recv()).] General network error. Check you network documentation. Error source: Microsoft
OLE DB Provider for SQL Server Help file: Help context 0. Process Exit Code 1. The step failed.
The job has working perfectly for the last 5 years, until about a week ago when it started failing.
I have two other servers with the exact same configuration running the same DTS packages and job that still work and the DTS packages show up in Enterprise
View Complete Post