[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Import and Export Wizard Warnings (SQL 2008 R2)

Posted on 2014-01-09
6
Medium Priority
?
506 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore 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.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

656 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