SQL Import and Export Wizard map nvarchar(max) to its equivalent data type in csv

Question

Using SQL Import and Export Wizard i am importing data from csv file to SQL tables, but in SQL Table is having Column data type nvarchar(max) and i have to convert my data type equivalent to nvarchar(max), i am Tried DT_STR , DT_WSTR,. and according to my R&D i got link that i want to share with you

=> http://msdn.microsoft.com/en-us/library/ms141036.aspx =>Mapping of Integration Services Data Types to Database Data Types

so there is no such kind of conversion for nvarchar(max). so if anyone knows then do the needful. thanks in advance.

Answer 1

You can use text stream [DT_TEXT] or Unicode text stream [DT_NTEXT].

Resource:

The SQL Server Integration Services Data Type Map

SSIS to SQL Server Data Type Translations