I am trying to import a large Access(.mdb) file into SQL Server 2008, and I’m getting the messages below. Any ideas?
– Pre-execute (Error)
Messages
Error 0xc0202004: Data Flow Task 1: The number of columns is incorrect.
(SQL Server Import and Export Wizard)
Error 0xc0202025: Data Flow Task 1: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task 1: component “Destination – Parnell_Byte_Mgrs_Pt2” (61) failed the pre-execute phase and returned error code 0xC0202025.
(SQL Server Import and Export Wizard)