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.
March 14, 2008 7:31 AM
March 17, 2008 5:12 AM