Home Dashboard Directory Help
Search

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


Status: 

Active


10
0
Sign in
to vote
Type: Bug
ID: 773832
Opened: 12/7/2012 3:04:58 PM
Access Restriction: Public
1
Workaround(s)
view
7
User(s) can reproduce this bug

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
------------------------------
Details
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
Sign in to post a workaround.
Posted by Corey G DW on 4/30/2013 at 1:10 PM
The following consistently works for me.

Click the Edit Mappings button then in the Destination column click on each row effectively setting the focus in each Destination item. Then click the Ok button.