Fuzzy Lookup[4506] Error in Integration Services

Hi:

I m developing Integration Services Project with Fuzzy Services.

as Provided in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/FzDTSSQL05.asp

am running its Simple example with database AdventureWorks and table Products (I hve also tried other tables). but its failed to execute b/c of this error

[Fuzzy Lookup [4506]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Multiple identity columns specified for table 'FuzzyLookupMatchIndexEmployee_FLRef_060705_10:21:09_2408_afc874d3-927b-4c70-95ad-a726ef6d7567'. Only one identity column per table is allowed.".

Can any buddy help me out.

Try deselecting the "Store new index" option.|||I hve tried it , but Error still same|||I'm having this problem. I'm curious if you were ever able to resolve it? Any help would be greatly appreciated.

Fuzzy Lookup[4506] Error in Integration Services

Hi:

I m developing Integration Services Project with Fuzzy Services.

as Provided in http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/FzDTSSQL05.asp

am running its Simple example with database AdventureWorks and table Products (I hve also tried other tables). but its failed to execute b/c of this error

[Fuzzy Lookup [4506]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Multiple identity columns specified for table 'FuzzyLookupMatchIndexEmployee_FLRef_060705_10:21:09_2408_afc874d3-927b-4c70-95ad-a726ef6d7567'. Only one identity column per table is allowed.".

Can any buddy help me out.

Try deselecting the "Store new index" option.|||I hve tried it , but Error still same|||I'm having this problem. I'm curious if you were ever able to resolve it? Any help would be greatly appreciated.sql

Fulltext Search, Contains, Varbinary, AdvantureWorks

Hello all

I am trying to full text search in the Documnt table in AdvantureWorks DB.

as in the video sample microsoft provided.

I create the unique index on DocumentID column and created the FullTextIndex:

create fulltext index on Production.Document

(

Document

Type column FileExtension

Language 0X0

)

Key index ui_ProductionDocument on MyFullTextCatalog

With change_tracking auto

Now I am trying to run the next search:

select * from Production.Document

where Contains(Document,'?????')

and I get nothing back, what do I do wrong?

I was having a pending restart that fixed the all thing.

Don't know why....