• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4336
  • Last Modified:

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

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?
0
R7AF
Asked:
R7AF
  • 3
  • 2
1 Solution
 
PFrogCommented:
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 http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx for a comparison of the features.
0
 
R7AFAuthor Commented:
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.
0
 
PFrogCommented:
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?
0
 
PFrogCommented:
To clarify my last post - please check out
   http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
0
 
R7AFAuthor Commented:
>> 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!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now