SQL Import and Export Wizard maps nvarchar (max) equivalent data type in csv

Question

Using the SQL Import and Export Wizard. I am importing data from a csv file into SQL tables, but there is an nvarchar (max) column data type in the SQL table, and I need to convert my data type equivalent to nvarchar (max), I am Tried DT_STR, DT_WSTR ,. and according to my R&D, I got a link that I want to share with you.

=> http://msdn.microsoft.com/en-us/library/ms141036.aspx => Mapping Integration Services data types for database data types

therefore there is no such conversion for nvarchar (max). therefore, if someone knows, then make it necessary. thanks in advance.

Answer 1

[DT_TEXT] Unicode [DT_NTEXT].

:

SQL Server

SSIS SQL Server Data Type Translations