Tuesday, November 15, 2011

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Requirement:  Migrate Data from Access to SQL Server.

So I have to create SSIS Package in SQL Server and I developed on SSIS Package in SQL Server.
All connection managers are fine but when I try to deploy its give me below error.

Error: [OLE DB Source [43]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Access Source Database1" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.


Resolution: Open SSIS Package in Visual Studio > Right Click on Project > Click on Property of your project > Then select "Debugging" node from left side > See the "Run64bitRuntime" property it will be "True" so change it to "False"
Then Deploy again... it will be work...


Happy Migrating...!!!

No comments:

Post a Comment