Friday, 20 June 2008

The Dreaded SSIS Error Code DTS_E_PRODUCTLEVELTOLOW

While attempting to deploy some SSIS packages today to a clients Development environment, I started receiving the Error Code DTS_E_PRODUCTLEVELTOLOW and my packages started crashing. Turns out that although the production Server is running Enterprise version and the Test Server is running Developer version, the actual development server itself was only running the Standard version of SQL.

I thought this was a good time to remind everyone that you will need the Enterprise Version of SQL Server 2005 (or Developer version if its a test or development environment) if you intend on using any of the below Integration Services components:

  • Data Mining Training Destination
  • Data Mining Query Component
  • Fuzzy Grouping
  • Fuzzy Lookup
  • Term Extraction
  • Term Lookup
  • Data Mining Query Task

2 comments:

Douglas Laudenschlager said...

This blog post provides some updated information on "components by edition" for SQL Server 2008.

-Doug

Catherine said...

Thanks Doug. :)