I have a flat file which I am importing into a SQL Server table using a SSIS package. The code page is set to 65001.
However, when I run a
SELECT * FROM tableName
the data appears mangled. For some reason it is not being stored in Unicode. The column is
nvarchar, so that should not be an issue.
Also, if I insert data manually, the data is stored as expected.
What could be going wrong?