Access 2000 MDB to SQL import using SSIS - Validation error
Hi, I'm trying to import an Access 2000 MDB file into an SQL Database using SSIS 2008 and the OLE DB Source Data Flow component. I can preview the resilts in the config window for the OLE DB Source but when I run the task it fails on the OLE DB Source component with the following error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "\\BOXSERVER\eLaser\Backup\LASERNET.MDB" failed with error code 0xC0209303 Component "ImportDB" failed validation and returned error code 0xC020801C What does a failed validation usualy mean? Thanks in advance.
August 21st, 2011 7:08am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics