Excel Import Data Conversion Task Can not convert between a unicode and non unicode string

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

Add a data conversion task to make your data types match.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Phil Parkin (11/16/2016)
Add a data conversion task to make your data types match.

I did but I do not have the data types right.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/