SSIS 2016. importing a column from text file into sql server table into a column of NVARCHAR(50) datatype. getting errors that nonunicode and unicode datatypes source/destination cannot be resolved. What is the best way to overcome that?
SSIS 2016. importing a column from text file into sql server table into a column of NVARCHAR(50) datatype. getting errors that nonunicode and unicode datatypes source/destination cannot be resolved. What is the best way to overcome that?
thank you.
Add a data conversion transformation to convert to unicode before inserting.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply