SSIS 2019 How to output nvarchar(max) column to flat file CSV UTF-8-CodePudding

SSIS Visual Studio 2019 - Microsoft SQL Server 2019

I need to output using SSIS to a CSV UTF-8 file a SQL Server column which is nvarchar(max).

I have tried to convert but DT_WSTR has a 4,000 character limit and DT_STR 8,000.

Is there anyway to output data to CSV no matter the length of the column field?

CodePudding user response：

For getting UTF-8 instead UCS-2 of you need to do this

In Source -> Advance Editor -> Component Properties -> Set Default Code Page to 65001 AlwaysUseDefaultCodePage to True. Then Source->Advance Editor -> Input And OutPut Properties Check Each Column in External Columns and OutPut Columns and set CodePage to 65001 wherever possible.

Source: https://social.technet.microsoft.com/Forums/en-US/a4854706-0d22-48c8-bc82-109630d23376/how-to-export-to-utf8bom-flat-file?forum=sqlintegrationservices