SQL Server Performance Forum – Threads Archive
Error when executing the SSIS
Error when executing the SSIS in Visual Studio 2005The 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? http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=293 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
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ 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 http://www.eggheadcafe.com/software/aspnet/30131828/the-acquireconnection-met.aspx
http://blogs.conchango.com/jamietho…rticle_3A00_-SSIS-Package-Configurations.aspx —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
]]>