Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Import and Export Wizard Warnings (SQL 2008 R2)

Posted on 2014-01-09
6
Medium Priority
?
523 Views
Last Modified: 2014-01-10
I am trying to export from a SQL database to Excel format using the Wizard. I put my query in and then I get the "Review Data Type Mapping" screen which has a bunch of Yellow Exclamation Points (WARNINGS).  See attached document.

 I don't know what to do to fix these or why I'm getting them. Can anyone help?
DataTypeMapping.gif
0
Comment
Question by:CityofDelrayBeach
  • 3
  • 3
6 Comments
 
LVL 5

Accepted Solution

by:
dannygonzalez09 earned 2000 total points
ID: 39768464
You see those warning messages because the data types in the source and the destination don't match...

try to run the wizard and see if the data gets inserted into the table or not...


Just continue to the next time, since you've the On error (global) set to Fail by default, the task will fail, if it cannot insert the data into the table with an error message and then we can try to convert the data type, if necessary
0
 

Author Comment

by:CityofDelrayBeach
ID: 39768490
Thanks Danny.

Attached are the Result screen and the Warning Message.
Export-Result-Screen.jpg
Warning-Messages.jpg
0
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39768529
do you see all the data that you were trying to import in your table?
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 

Author Comment

by:CityofDelrayBeach
ID: 39768555
It's actually an export to an Excel file. I'm trying to check with the vendor if all the data is there, but I was just concerned with all those Warnings.  So should I just ignore them?
0
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39768577
Oh..ok

that shouldn't be a problem then but i would suggest using a csv rather than excel
0
 

Author Comment

by:CityofDelrayBeach
ID: 39771225
Thanks Danny!  I am using the Excel format and just ignoring the Warnings and all the data is coming through!
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Integration Management Part 2
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question