I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1
and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2.
So I connected from server1 created a DTS package and saved it.After this I opened the package by connecting to
Integration services and executed the project. But I get a error
Error: The AcquireConnection method call to the connection manager "DestinationconnectionOLEDB" failed with error code 0XC0202009.
If I execute the same SSIS package with execute immediately and save SSIS package the package executes successfully.But if I
open the same saved package next time and execute I get the same error.
Please help me to figure out why this happens when a package
can execute successfully while the same saved package throws out error when opened in SSIS.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!