I have a new SSIS project that I upgraded from VS 2010. The task starts by opening three databases. The connections to all three databases refer to the same server and same SQL instance. The only difference is the database. When I run the project I get this error message.
"[Account ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ERPCurrentDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed."
I can browse the data within the task but I cannot run the project. I have tried switching to 32 bit and setting DelayedStart to True and neither has helped. What else can I check?