Solved

Import and Export Wizard Warnings (SQL 2008 R2)

Posted on 2014-01-09
6
452 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

948 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now