Fuzzy Lookup between a SQL 2000 and 2005 database problem

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Fuzzy Lookup between a SQL 2000 and 2005...

Fuzzy Lookup between a SQL 2000 and 2005 database problem

Rate Topic

Display Mode

Topic Options

Author

Message

koln

Posted Wednesday, April 08, 2009 11:28 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, February 07, 2013 10:11 AM
Points: 70, Visits: 224

Hi folks,

I build a SSIS package, which contains a fuzzy lookup process on a SQL Server 2005, SP2. It runs fine by itself. It compares names found in a SQL Server 2000 database, to names found in a SQL Server 2005 database.

The problem arises when I schedule this package to run via a job in SSMS. It keeps giving me the error of "SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup" (43)."
The SQL Server 2005 box that this job and SSIS package is on, is standard edition.

Why does it run fine in SSIS, but not as a job in SSMS, when everything is on one box ?

Thank you.

Post #693385

Jack Corbett

Posted Wednesday, April 08, 2009 1:58 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 10,571, Visits: 11,871

You probably have Developer Edition on the PC where you are developing the package which allows the Fuzzy lookup to work, but Standard Edition does not include the Fuzzy Lookup component because it is considered an "Advanced Transform" which are only included in Enterprise Edition.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #693539

koln

Posted Wednesday, April 08, 2009 2:02 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, February 07, 2013 10:11 AM
Points: 70, Visits: 224

No, thats the big mystery...Im not running it from my PC....I have remote desktopped into the SQL Server, build my SSIS package there...run it successfully within SSIS on the server, yet when I schedule it as a job, it fails.

Post #693543

Gift Peddie

Posted Wednesday, April 08, 2009 2:51 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 29, 2013 11:17 AM
Points: 3,432, Visits: 14,332

I think your problem is BIDs issue because it develops SSIS packages as needed but require correct edition for deployment because both Fuzzy features comes only in Enterprise edition.

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

Kind regards,
Gift Peddie

Post #693590

« Prev Topic | Next Topic »

Permissions