Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS Package running from only one machine

Author  Topic  hkuntal Starting Member 3 Posts Posted - 2007-12-13 : 08:40:46 Hi, I created a simple SSIS package that would transfer data from one database to the other database on the same server. When I double click the .dtsx file on the machine I created the exe utility runs the package successfuly. However if I try to run the same dtsx file from the other machine I get the following error.... Error : The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0*C0202009 Any reason why is it happening...? The connection string is same in both the cases.