We help IT Professionals succeed at work.

Sql Server Export errors

3,429 Views
Last Modified: 2016-02-10
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).

Thanks in advance.
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Creating a view in SSMS did the trick! Thank you!!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.