Error Integration services connention Microsoft access
Posted on 2009-04-07
i have make a connection in integration services to Microssoft access, i use provider NATIVE OLE DB/MICROSOFT JET 4.0 OLE DP PROVIDER, (with and without user and password of admin), and made a DATA FLOW TASK to send rows from access to sqlserver table .But generate a eror:
" [OLE DB Source ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MICONEXION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. "
Where is the problem?