Can't export to CSV from SQL Server 2012 Import/Export Wizard - by SQLNoobie

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


10
0
Sign in
to vote
ID 773832 Comments
Status Closed Workarounds
Type Bug Repros 7
Opened 12/7/2012 3:04:58 PM
Access Restriction Public

Description

Please see "Details" section below for more info about the exact steps I am taking to come produce this error. I am unable to do a simple export to CSV using SQL Server 2012 (I am able to from SQL Server 2008 however). This is the error message I get when trying to export from a database to a CSV file, using the Import/Export Wizard:


TITLE: SQL Server Import and Export Wizard
------------------------------

Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider.


[Query] -> C:\Users\NEW\Desktop\TEST.csv:

	      - Column "last_name": Source data type "200" was not found in the data type mapping file.
	      - Column "first_name": Source data type "200" was not found in the data type mapping file.
	      - Column "middle_name": Source data type "200" was not found in the data type mapping file.
	      - Column "suffix": Source data type "200" was not found in the data type mapping file.
	      - Column "title": Source data type "200" was not found in the data type mapping file.

------------------------------
BUTTONS:

OK
------------------------------
Sign in to post a comment.
Posted by Helen [MSFT] on 9/8/2015 at 7:04 PM
Thank you for submitting this feedback. After carefully evaluating the bug, we would like to seek more information from you for us to better understand the issue. Can you please provide more information and respond to the below questions:

1.Did you export the sample table on the SQL Server 2008?
2.What is the schema for the export table? You can use the command "SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = {table name}'" to get the schema information.

Thanks again for reporting the product issue and continued support in improving our product.
Posted by SQLIZR on 10/2/2013 at 2:18 PM
I am having the same issue but I do not have SQL 2012 installed. I have VS2012 and SSDT 2012 installed, but SSMS is still 2008 R2 SP2