SSIS The product level is insufficient for component "Fuzzy Grouping"

Hot Topic

SQL Server 2005 SP1 "GetServiceuserGroup failed"
Giant White Space Shows Up When Viewing In Report Manager Only
sp and joins... please help!!
What does the componentMetadata.FireError method do?
Package Migration Wizard error -- Index was out of range
FTP task
Error rsFailedToDecryptConfigInformation
SQL Server 2000 sign-on to 2005
Reusing package configuration file across all packages in a solution?
Parameter problem

SQL Server

Importing CSV file with URL using DTS???
Difference between these two SQL Express
Can't Connect to Reportserver using Management Studio
Unable to access Report Manager
how could I store images in a database??!!
Instert found records into DB
Cannot Install SQL Server 2005 along side SQL Server Express
auto numbering
Export data to Excel file is very big files.
To add one report or many

SSIS The product level is insufficient for component "Fuzzy Grouping"

Hello,

I have a Dataflow with a Fuzzy Grouping component. When I load this package in my application and execute it, i get the following error message:
The product level is insufficient for component "Fuzzy Grouping" (561).

Whithout the Fuzzy Grouping component the Dataflow works properly.

I work on a client machine with following installations: framework 2.0, SQL 2005 Standard with all services, VS 2005. 

What's wrong, can you help me

Regards Ralf


DTSExecResult dTSExecResult = package.Execute();

if (dTSExecResult == DTSExecResult.Failure)

{

foreach (DtsError error in package.Errors)

{

string msg = error.Description;

}

}

 

Answer this question

SSIS The product level is insufficient for component "Fuzzy Grouping"

  • Steve Q

    Ralf,

    Unfortunately Fuzzy Grouping feature is not available for standard version users (It is availabe in ENT or DEV versions)

    Thanks
    Wenyang

  • beN!

     Cridal69 wrote:
    I'm getting the same message after trying to execute a package deployed to a server running SQL Server Standard edition WITH Integration Services installed and running (I was able to execute the packages in development).

    I would appreciate any suggestions...

    Please see Wenyang reply above:

     Wenyang Hu wrote:
    Fuzzy Grouping feature is not available for standard version users (It is availabe in ENT or DEV versions)

    It is considered an advances feature, requiring Enterprise (or Developer) edition.



  • KevinKan

    SSIS should be installed (not just Workstation tools) on any machine where the package is executed. Workstation tools allow one to develop (design and debug packages in VS), but are not enough to execute packages.

  • NimoTh

    Hello,

    now I have Integration Services "Developer Edition" on my workstation and all works fine.

    Thank you very much.

    Ralf

  • Thore

    I don't have any Fuzzy Grouping functionality in the package. It's a simple package that pulls data from one table to another...

  • Hrongold

    I'm getting the same message after trying to execute a package deployed to a server running SQL Server Standard edition WITH Integration Services installed and running (I was able to execute the packages in development).

    I would appreciate any suggestions...

  • 13one

    Hello Wenyang,

    thank you for your answer. We try another installation. Now we have SQL 2005 Enterprise on a Server and Workstationtools (Enterprise Edition) on a Client. But there is still the same error.

    When I start the Dataflow in VS, there is no problem. Only when I execute it in my application.

    Regards Ralf

    Server:

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    Client:

    Microsoft Visual Studio 2005
    Version 8.0.50727.42  (RTM.050727-4200)
    Microsoft .NET Framework
    Version 2.0.50727

    Installed Edition: Enterprise

    Microsoft Visual Basic 2005   77642-113-3000004-41031
    Microsoft Visual Basic 2005

    Microsoft Visual C# 2005   77642-113-3000004-41031
    Microsoft Visual C# 2005

    Microsoft Visual C++ 2005   77642-113-3000004-41031
    Microsoft Visual C++ 2005

    Microsoft Visual J# 2005   77642-113-3000004-41031
    Microsoft Visual J# 2005

    Microsoft Visual Studio Tools for Office   77642-113-3000004-41031
    Microsoft Visual Studio Tools for the Microsoft Office System

    Microsoft Visual Web Developer 2005   77642-113-3000004-41031
    Microsoft Visual Web Developer 2005

    Visual Studio 2005 Team Edition for Developers   77642-113-3000004-41031
    Microsoft Visual Studio 2005 Team Edition for Software Developers

    Crystal Reports    AAC60-G0CSA4B-V7000AY
    Crystal Reports for Visual Studio 2005

    SQL Server Analysis Services  
    Microsoft SQL Server Analysis Services Designer
    Version 9.00.1399.00

    SQL Server Integration Services  
    Microsoft SQL Server Integration Services Designer
    Version 9.00.1399.00

    SQL Server Reporting Services  
    Microsoft SQL Server Reporting Services Designers
    Version 9.00.1399.00
  • SSIS The product level is insufficient for component "Fuzzy Grouping"
Answer this question