Error when executing the SSIS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error when executing the SSIS

Error when executing the SSIS in Visual Studio 2005
The AcquireConnection method call to the connection manager "EDR_Prod" failed with error code 0xc020… Requested value Synonym was not found
Are you running any distributed queries? fyi, though not entirely related to SSIS but worth checking it. For me it indicates that the destination can not acquire the connection to the destination connection, see what is the destination type. If it is a SQL Server then ensure proper protocols are matching between the instances or if its an excel file then ensure the path exists and relevant jet drivers are installed. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Are you using package configurations…rticle_3A00_-SSIS-Package-Configurations.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at