Solved

Import and Export Wizard Warnings (SQL 2008 R2)

Posted on 2014-01-09
6
465 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 500 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

685 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