Hi, I have developed a package in 2005 and it running fine there but when same package i trying to run in 2008 it is throwing below errors. Please anyone can help me out. I have SP1 not SP2 1 [OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The Acquire Connection method call to the connection manager "SQL_SOURCE" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. 2 [Execute SQL Task] Error: Failed to acquire connection "SQL_DESTINATION". Connection may not be configured correctly or you may not have the right permissions on this connection.Thanks Shiven:)

Have you used 'test connection' in the connection manager? Are your connection strings set correctly? Are they populated by an expression/variable/config file? Are you running 2008 on the same machine as 2005? If not does it have permissions to 'see' the database you are trying ot connect to? Phil

Hi, Please check the connection as Phil suggested. And another related blog you can refer to; http://blogs.msdn.com/b/ramoji/archive/2009/03/10/the-acquireconnection-method-call-to-the-connection-manager-failed-with-error-code-0xc0202009.aspx Hope this helps, Raymond Raymond Li - MSFT