Error Importing Access file into SQL Server 2008 - TechRepublic
General discussion
May 28, 2010 at 08:38 AM
abe_froman

Error Importing Access file into SQL Server 2008

by abe_froman . Updated 16 years, 1 month ago

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)

This discussion is locked

All Comments