Wednesday, 15 August 2012

[OLE DB Source_Access [29]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.


That was an SSIS to transfer data from an Access DB 2007 into SQL Server 2012 using SSIS


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


SET RUN 64 to False from the project properties:






No comments:

Post a Comment