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

Posted on 2007-10-03
Last Modified: 2009-02-17
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.

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?
Question by:R7AF
    LVL 18

    Expert Comment

    There are a number of features of SSIS that are only available in the Enterprise edition, I'm guessing that you're running Standard?
    Check out for a comparison of the features.
    LVL 13

    Author Comment

    Thanks for your reply. You're correct that I'm using Standard Edition. I could test if installing Enterprise edition will solve this, but I don't believe SE doesn't support it.

    Looking at "Integration and Interoperability", I see that import and export is supported in SE. This is a simple import, with one worksheet, only some data rows, nothing special. If I start the import wizard, I can see the data. Only when I click "Finish" I get an error.

    The support forums talk about SE as well, that they have it working. I don't think this is the problem.
    LVL 18

    Accepted Solution

    Which machine are you actually trying to run the package on? Is it actually being run on the machine with SQL Server & SSIS installed? Or on a client machine?
    LVL 18

    Expert Comment

    To clarify my last post - please check out
    LVL 13

    Author Comment

    >> Which machine are you actually trying to run the package on?

    It took some time before I really understood what you meant, and it's so simple. I installed the package on the server, and ran Management Studio from my desktop. That didn't work. When I run it from the server's Management Studio, it works.

    Thanks for this tip!

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
    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…

    728 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

    19 Experts available now in Live!

    Get 1:1 Help Now