Hello! I have a package that contains some dataflows, within the dataflows I have a lookup that checks the existence of the record before it is inserted into the target table. In my test environment it works perfect, but in the production environment, i received the error below: . Started: 11:36:58 AM Error: 2011-10-17 11:39:18.38 Code: 0xC0202009 Source: MB_ADT_EXPURGO_2005 Connection manager "DB_DESTINATION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: On... The package execution fa... The step failed. This error begun when i started to use the Lookup, before it worked fine!!! Can you help me? thanksDBA SQL SERVER - MCTS SQL SERVER 2008 Twitter : afalanque www.alessandrofalanque.wordpress.com

Hi Alessandro Falanque, According to the error message that you have provided above, I suspect that might be a remote connection issue, please refer to the following KB: How to configure SQL Server 2005 to allow remote connections: http://support.microsoft.com/kb/914277 Hope that helps. Thanks, Eileen