SQLTeam.com | Weblogs | Forums

Unicode Error importing from CSV File

Hi experts,
I have a .csv file I'm trying to import into SQL Table. The table columns are defined as nvarchar.

The Data Flow task shows this error: "Column 0 cannot convert between unicode and non-unicode"
I'm at a loss for what to do. I even made the table columns varchar but that fails too.
Excel and .csv data is by default unicode/nvarchar correct?
What can I do?

Go into advanced editor for source and destination columns and see what they are defined as. Look in each component. One is treating as varchar and the other is nvarchar.

1 Like

Thanks, I revisited Mikes comment and dug deeper. I changed most of the data types to DT_WSTR and now the warning doesn't show. Thanks guys.