Advertisement

10.03.2007 at 07:58AM PDT, ID: 22869356
[x]
Attachment Details

The product level is insufficient (importing Excel sheet into SQL Server)

Asked by R7AF in SQL Server 2005, MS SQL Server, Microsoft Excel Spreadsheet Software

Tags: level, product, insufficient, sql, excel

I'm trying to import an Excel 2003 datasheet into SQL Server 2005 SP3, with SSIS installed and reinstalled. I get the folllowing error:

Error 0xc00470fe: Data flow task: The product level is insufficient for component...

When I search for this error, I get the following results.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1
http://forums.microsoft.com/msdn/showpost.aspx?postid=110020&siteid=1
http://www.experts-exchange.com/Q_22705097.html

Basically it says:

1) Install SP1 (SP2 installed)
2) Install SSIS (done)
3) Try to reinstall SSIS (done)

Still it doesn't work. Any ideas what I can do?Start Free Trial
[+][-]10.03.2007 at 08:52AM PDT, ID: 20007641

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.03.2007 at 12:31PM PDT, ID: 20009335

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.04.2007 at 01:12AM PDT, ID: 20012515

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server, Microsoft Excel Spreadsheet Software
Tags: level, product, insufficient, sql, excel
Sign Up Now!
Solution Provided By: PFrog
Participating Experts: 1
Solution Grade: A
 
 
[+][-]10.04.2007 at 01:14AM PDT, ID: 20012523

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.05.2007 at 01:51AM PDT, ID: 20020363

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628