April 8, 2009 at 11:28 am
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.
April 8, 2009 at 1:58 pm
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
Consultant - Straight Path Solutions
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
April 8, 2009 at 2:02 pm
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.
April 8, 2009 at 2:51 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply