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

ssis sql-import-wizard
Monal picture Monal · Jun 23, 2014 · Viewed 10.8k times · Source

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

Vikramsinh Shinde picture Vikramsinh Shinde · Jun 23, 2014

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

Related questions

How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More
What is the SSIS package and what does it do?

Can someone tell me what the SSIS package is all about? I am totally new to data-warehousing and I am going crazy with the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how …

Read More