June 15, 2011 at 8:51 am
I am using SSIS visual studio 2005 professional edition. When I execute the package in visual studio it executes fine. But, when I try to execute using DTSExec Utility then it is using the following error:
SSIS Error Code DTS_E_PRODUCTLEVELTOOLOW. The product level is insufficient for component “Fuzzy Lookup” (22967)
It starts executing then stops at 'fuzzy lookup' task.
Please help me.
June 15, 2011 at 8:57 am
Visual Studio 2002 ???
You need SQL Server Enterprise Edition to use fuzzy lookup.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 15, 2011 at 9:31 am
It is VS 2005 but, professional edition. So, no other option then?
June 15, 2011 at 9:33 am
Not that I know of - maybe someone else will have some ideas.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 16, 2011 at 5:20 am
What version and edition of SQL Server do you have installed?
Run SELECT @@Version on SSMS and return the results, please.
June 16, 2011 at 7:50 am
Thank you so much for the response. I got the following version:
Microsoft SQL Server 2005 - 9.00.4285.00 (X64) Feb 8 2010 23:31:46 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
June 16, 2011 at 8:08 am
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.
Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available in both Standard and Enterprise, and I don't seen any BOL commentary that says this is an Enterprise only feature. In fact, I've never heard of SSIS components that only work with Enterprise.
More details on the source of this would be appreciated.
June 16, 2011 at 8:18 am
Brandie Tarvin (6/16/2011)
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available in both Standard and Enterprise, and I don't seen any BOL commentary that says this is an Enterprise only feature. In fact, I've never heard of SSIS components that only work with Enterprise.
More details on the source of this would be appreciated.
Check here. Compare Standard and Enterprise and look under Integration Services - Advanced Transforms.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 16, 2011 at 9:02 am
Phil Parkin (6/16/2011)
Brandie Tarvin (6/16/2011)
Phil Parkin (6/15/2011)
You need SQL Server Enterprise Edition to use fuzzy lookup.Phil, where did you get the idea that fuzzy lookup is only available to Enterprise Edition? SSIS is available in both Standard and Enterprise, and I don't seen any BOL commentary that says this is an Enterprise only feature. In fact, I've never heard of SSIS components that only work with Enterprise.
More details on the source of this would be appreciated.
Check here. Compare Standard and Enterprise and look under Integration Services - Advanced Transforms.
That's 2008 R2. We're talking about 2005.
June 16, 2011 at 9:16 am
Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 16, 2011 at 9:20 am
radb4u, My previous post is not saying Phil is wrong. Generally, these things don't change between editions. But I have yet to find the pudding to find the proof that 2005 works the same way.
In the meantime, are you running the DTSExec on your PC or against a SQL Server? Where is the package located when you run this utility (on the PC or the server)? Answer both questions, even if they are the same answer, please.
June 16, 2011 at 9:22 am
Phil Parkin (6/16/2011)
Ah indeed. OK, try this one (it's a big page, search for fuzzy and you'll find it towards the end of the page).
Ahha! There we go. Thanks for that link.
radb4u, it looks like you will have to manually code your fuzzy lookup in a Script Task or a SQL Server proc.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply