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?