To import large text including special and foreign characters using Flat File follow this; External Column =  Text_Stream (DT_TEXT) Output Column = Unicode Text Stream (DT_NTEXT) This can handle up to 11000 characters. I think it’s more than sufficient. Make sure your SQL Database has NVARCHAR(MAX) column data type. This will work if the column … Continue reading Large text import from Flat File using SSIS