SSIS package executing only from the machine on which it was created.

• hariomsingh_kuntal

  Old Hand

  Points: 346

  More actions

  December 13, 2007 at 6:51 am

  #177505

  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. Both Machine Logins have got proper user privliges.

• Powichrowski Marek

  Hall of Fame

  Points: 3423

  More actions

  December 14, 2007 at 2:53 am

  #760119

  Read this thread:

  http://www.sqlservercentral.com/Forums/Topic423399-148-1.aspx