Post reply

Product level insufficient for component Fuzzy Lookup

  • October 11, 2010 at 9:49 am

    #145631

    Hello all,

    I have developed an SSIS package in BIDS that utilises Fuzzy Lookups.

    Here are my version details.

    productversion -9.00.3042.00

    productlevel - SP2

    edition -Standard Edition (64-bit)

    When I attempt to execute the package by scheduling the package, its generating the error 'Product level insufficient for the component Fuzzy lookup'.

    Is there any other way of scheduling the fuzzy lookup package in standard edition?

    Any help is highly appreciated

  • October 11, 2010 at 9:55 am

    #1235086

    Fuzzy Lookups is not supported in the Standard Edition for either SQL 2005 or 2008.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 11, 2010 at 10:08 am

    #1235100

    Is there any way in standard edition to execute this package other than executing in bids?

  • October 11, 2010 at 10:17 am

    #1235110

    Take a look at DTExec and DTExecUI.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 12, 2010 at 5:10 am

    #1235398

    Thanks for reply, but dtexec and dtexecui are giving the same error

    Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup" (16).

    Any other way of executing the fuxxy lookup package in sql standard edition?

    Any help is really appreciated

  • October 12, 2010 at 5:51 am

    #1235423

    Deepthy (10/12/2010)

    Thanks for reply, but dtexec and dtexecui are giving the same error

    Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup" (16).

    Any other way of executing the fuxxy lookup package in sql standard edition?

    Any help is really appreciated

    No, its not supported in Standard it does not make a difference how you execute the package.

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

    you could try using full-text search or building your own 'fuzzy' lookup with like filters

  • October 12, 2010 at 7:48 am

    #1235523

    steveb. (10/12/2010)

    Deepthy (10/12/2010)

    Thanks for reply, but dtexec and dtexecui are giving the same error

    Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup" (16).

    Any other way of executing the fuxxy lookup package in sql standard edition?

    Any help is really appreciated

    No, its not supported in Standard it does not make a difference how you execute the package.

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

    you could try using full-text search or building your own 'fuzzy' lookup with like filters

    ... just to add a few words to Steve's answer ...

    The issue is not with BIDS. The issue is with the SSIS engine, which is the Standard Edition. It doesn't matter how you try to kick off the package, it's still the same engine that is running the package.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply