Trouble running the SSIS package on SQL server

Feb 27, 2009 at 2:25 PM
Hi,

I've succeeded in creating a package that extract data from SharePoint and manipulate the data (Execute SQL Task).  Everything works fine from SQL Server Business Intelligence Development Studio.  Now when I've imported that package to SQL 2005 in the Integration Services, everything work in my package except the part where it's extracting data from SharePoint.

This is the error I get:

"Error: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component" "SharePoint List Source" (1)

Am I supposed to install the utility or the DLL on the server?

Thanks.


Coordinator
Feb 28, 2009 at 5:38 AM
Not sure if it helps, but I found this article with some suggestions.
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

You should not install the sample ssis component on the Sharepoint server.  This is something with your SSIS installation it sounds like. Not sure what, I've never seen this before.