I have DTS package which runs every night in prod and last night it did not ran and when Iam trying to investigate I see the following error messages
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Time-out occurred while waiting for buffer latch type 2 for page (3:90235), database ID 12.
The SQL Code in the package is it uses select from a linked server As400 .(DB2)
In test it runs the same through and SSIS Iam getting the below message
Failed to acquire connection "STop_AMLLIB".
Connection may not be configured correctly or you may not have the right permissions on this connection.
Below is the error message a few days ago
OnError,Set DWU,,,6/27/2009 12:48:37 AM,6/27/2009 12:48:37 AM,0,0x,
OLE DB provider "IBMDADB2" for linked server "STop_AAGPROD" returned message " SQL30081N
A communication error has been detected. Communication protocol being used: "TCP/IP".
Communication API being used: "SOCKETS". Location where the error was detected: "10.20.30.11".
Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001