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