Solved

Why Can't I import data?

Posted on 2010-09-17
20
1,022 Views
Last Modified: 2013-11-05
I am trying to import data from an Excel file into a SQL table, using the Data Import wizard, but I keep getting this error when it tries to execute the import:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
 (SQL Server Import and Export Wizard)
 
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (90).
 (SQL Server Import and Export Wizard)
 
What does it mean, and what do I need to do to resolve it?
0
Comment
Question by:y2jk
[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
  • 7
  • 6
  • 4
  • +1
20 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 33699400
First things first, this looks like a product compatibility issue. Which version on Excel and which version of SQL Server do you have? Is SQL patched to the latest patch? Are the MDAC components upto date?

Lee
0
 
LVL 29

Expert Comment

by:QPR
ID: 33699441
Are you importing data into a sql 2000 (80) database that is hosted on a 2005/2008 SQL server?
0
 

Author Comment

by:y2jk
ID: 33699468
lsavidge; SQL 2005 and Excel 2003. I'll have to check with the tech boys to see about patches, MDAC etc etc.

QPR - good point, this is an older database (so most likely a 2000 version) on a newer box. Is that the possible reason for the error, and if so, what can I do about it?
0
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
LVL 29

Expert Comment

by:QPR
ID: 33699509
right click the db and check the properties - see if it is in 80 compatability mode.
SQL 2005 features are not enabled for DBs hosted in this mode
0
 

Author Comment

by:y2jk
ID: 33699535
OK tried that, but not sure where I should be looking or what I'm looking for. I couldn't see "80" on any of the screens anyway.
0
 
LVL 29

Expert Comment

by:QPR
ID: 33699567
right click on db - properties - options: compatability level
Will either say
sql server 2000 (80)
sql server 2005 (90)
sql server 2008 (100)
0
 

Author Comment

by:y2jk
ID: 33699578
Ah, yes, found it! It says sql server 2005 (90).
0
 
LVL 7

Expert Comment

by:wittyslogan
ID: 33699586
you could save the data as a csv file and then import it.  
0
 
LVL 29

Expert Comment

by:QPR
ID: 33699596
There goes that theory :)

Is service pack 1 installed?
Judging by this thread (and the one it refers to)... you are not alone in this
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_22705097.html

0
 

Author Comment

by:y2jk
ID: 33699656
I'll have to speak to the tech boys to see what is / isn't installed, and get my pc updated accordingly.

In the meantime, wittyslogan suggested converting to csv and then importing. I'll have a go at that and see what happens.

One other thing, when I try to script this (for the sys admins to apply it to the live database, as I'm only allowed access to the development box) the table in question contains just about every character on the keyboard. Scripting always puts all the data fields in single quotes, but with single quotes within the text as well, won't that screw up the data import? How else can I separate the data fields? If this is something I should raise as a separate question for separate points, then fair enough, just say so and I'll start a new question.
0
 

Author Comment

by:y2jk
ID: 33699701
Trying to use a csv gives me the same results. It errors in the "Validating" step of execution:

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - avamar2_csv" (1).
 (SQL Server Import and Export Wizard)

I also got about 20 occurences of this warning message as well:

Warning 0x80047076: Data Flow Task: The output column "Column 2" (16) on output "Flat File Source Output" (2) and component "Source - avamar2_csv" (1) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
 (SQL Server Import and Export Wizard)

What does that mean?
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 33699728
I would import from an xls file, not a csv.

Lee
0
 
LVL 7

Expert Comment

by:wittyslogan
ID: 33700481
do you have ssis installed.  I'm only asking because isn't the import export wizard part of ssis.

It might be called business intelligence.
0
 
LVL 7

Expert Comment

by:wittyslogan
ID: 33700494
sorry the product might be called business intelligence on the components bit.
0
 

Accepted Solution

by:
y2jk earned 0 total points
ID: 33820584
Turns out that I have all the client side tools I need, but I don't have the server side tools. That's why I can't upload data.
0
 
LVL 29

Expert Comment

by:QPR
ID: 33825531
server side tools? You mean the database engine? If so, how were you able to tell us the compatibility mode that the Db was hosted at?
Can you elaborate on server side tools?
0
 

Author Comment

by:y2jk
ID: 33829052
Er, not really! That's all the tech guy told me. His explanation was:- when he signs on to the SQL server he creates an instance of it on his pc, but when I sign on I am just connecting to the server. I have admin rights over my databases but that's all.

I'm still none the wiser, but does that explain it to you?
0
 
LVL 29

Expert Comment

by:QPR
ID: 33829081
not really, makes absolutely no sense :)
But if he can't/won't explain then you won't be able to. Just helps when the explanation is posted so future people can maybe find answers to similar questions.
Thanks for coming back and explaining though
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 33945723
I think you need a new "tech guy"

Lee
0
 
LVL 7

Expert Comment

by:wittyslogan
ID: 33945750
Personally I would check if importing your data is part of your job.  If it is then go to the "tech Guy" and askhim to give you the permissions you need to do that.  Or a written and signed explanation of why he won't.  

I'm with isavidge.  The solution is "get a new tech guy"
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

617 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