Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fuzzy Lookup between a SQL 2000 and 2005 database problem Expand / Collapse
Author
Message
Posted Wednesday, April 8, 2009 11:28 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 6, 2014 3:19 PM
Points: 72, Visits: 261
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
Posted Wednesday, April 8, 2009 1:58 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 10:57 AM
Points: 10,387, Visits: 13,454
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
Posted Wednesday, April 8, 2009 2:02 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 6, 2014 3:19 PM
Points: 72, Visits: 261
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
Posted Wednesday, April 8, 2009 2:51 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 13, 2014 2:52 PM
Points: 3,428, Visits: 14,451
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 »

Add to briefcase

Permissions Expand / Collapse