Connecting Tech Pros Worldwide Forums | Help | Site Map

export my sql server database to msaccess - Validating (Error)

Familiar Sight
 
Join Date: Oct 2008
Posts: 128
#1: Jan 23 '09
i cannot export my sql server database to msaccess database which i usually did successfully 3weeks ago pls help me to find the error
so that i can correct it in future

error is

- Validating (Error)
Messages
* Error 0xc02020f6: Data Flow Task: Column "Project ID" cannot convert between unicode and non-unicode string data
types.
(SQL Server Import and Export Wizard)

* Error 0xc02020f6: Data Flow Task: Column "Title of the Project" cannot convert between unicode and non-unicode
string data types.
(SQL Server Import and Export Wizard)


* Error 0xc004706b: Data Flow Task: "component "Destination - std project" (79)" failed validation and returned
validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

* Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

* Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

Reply