Experts - I am getting this error when attempting to export data from Sql Server 2012 Express:
Error 0xc020802e: Data Flow Task 1: The data type for "Destination - Export test_csv.Inputs[Flat File Destination Input].Columns[Title]" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
(SQL Server Import and Export Wizard)
What is the correct method (and in what application - sql server or the import/export wizard) to implement the solution in the error message:
Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
I have several columns that are nvarchar(4000) in my SQL Server table which I suspect are causing the error. The Export Wizard identifies these columns are Unicode string [DT_WSTR] data type.
3 other columns are numeric and it identifies them as either eight-buyte integer [DT_I8] or double-precision float [DT-R8).