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

Status : 

 


10
0
Sign in
to vote
ID 773832 Comments
Status Active 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 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