SQl2005 SSIS DTS_E_PRODUCTLEVELTOLOW

Hi I am trying to build an SSIS package to import text files to SQL data tables and then move the text files to a 'processed' file.

I can get the package to run successfully on my workstation in Visual Studio 2005 (although I got 'access denied' on the 'move' operation but I will worry about that later).

开发者_高级运维

However, when I deploy to the SQL server, and execute the package on the server, I get DTS_E_PRODUCTLEVELTOLOW error on the import to SQL stage. I have checked the SSIS service is running on the server which it is.

The data upload is very simple - just the first column from the text file plus the file name in two columns, so none of the 'smart' stuff that might not be installed.

Can anyone help?

Thanks!

---

http://msdn.microsoft.com/en-us/library/aa337371.aspx

says

Possible Causes

This message might appear because of one of the following problems:

• You have installed BI Development Studio but you have not installed Integration Services. Running packages outside Business Intelligence Development Studio requires the installation of Integration Services.

• Your package may be attempting to use advanced components for Analysis Services, data mining, or text mining that are available only in SQL Server Enterprise.

In the unlikely case you are using SQL Server 2005 without any service packs, there was a problem with running the Import-/Export Data Wizard. This problem was solved beginning with SP1.

A great collection of tips are in this blog post:

http://blogs.msdn.com/b/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Update:

To find out, what SQL Server Version you are running, execute the following query on your server:

 SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The second column of the result tells you the service pack level.