Hi,
I have a Access mdb which is having a table called NOI_Incident_Info contains few records. I also have SQL server 2005 database this database also having NOI_Incident_Info with same field stractures as in Access mdb. I would like to import data from access mdb (NOI_Incident_Info) into SQL server 2005 (NOI_Incident_Info) database. While doing this using SQL server Import/Export Wizard I got the following errors.

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

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

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

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


I changed datatype Varchar to nvarchar and char to vchar in SQL Server 2005 datatabase. After changing I got below errors.


Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "Incident_ID".
(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task: "component "Destination - NOI_Incident_Info" (122)" 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)



I tried converting data into csv files and imported into SQL db. it is showing that data sucessfully imported but no record is available in the table.




can anybody help me in solving this problem.


Thanks,
Uday