Why Doesn't Fuzzy Lookup include original source column in outputcolumn

Discussion in 'microsoft.public.sqlserver.dts' started by Crazy Cat, Jun 7, 2010.

  1. Crazy Cat

    Crazy Cat Guest

    I'm a newbie to SQL Server 2008 Integration Services (I have done some
    DTS packages in SS 2000) and I
    was wondering why the Fuzzy Lookup component does not include the
    original source key in the output
    column. I want to include it in a file called failed lookup (a record
    with a confidence of 0). Is this a bug ? I found
    that I could work around by adding the original source column

    Crazy Cat, Jun 7, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.