I'm developing a SSIS package to load a flat file into a table, but a warning appears on varchar fields:
Column "xyz" cannot convert between unicode and non-unicode strings data types.
The database is SQL_Latin1_General_CP1_CI_AI and the file was UTF-8, so that message makes sense.
Instead of adding filters, derived columns or whatever in the SSIS project, I could change the program that creates the flat file, so it is ANSI iso-8859-1 or Latin1 now, but the error message has not gone. I deleted the project and started a new one without success.
What am I missing?
Thanks a lot...