Hi,
I have a Microsoft Notepad flate file with data and Vertical Bar as column delimiter.
I get following message: cannot convert between unicode and non-unicode string data types
It seems it is my nvarchar(max) that creates my problem.
I changed to varchar(max); but still the same problem.
How do I insert my flate file into my SQL Server 2005?
And in the SQL Server 2005 import and export wizard the flate file source advanced tab the OutputColumnWith is 50. Will that say my flate file column is max 50? I hope not because my column is more then 50...
Thank you, Rune