I am trying to import a text file (tab delimited) including a long remark text with multiple lines.
I am using SSIS and face issue with Unicode and non unicode data type.
What is the best field type for the destination field in my table. to avoid import error?
Nvarchar (max) or Varchar (Max)?