asked on

Got bunch of error setting up a BIDS SSIS packag to do Fuzzy Match

Hi, I'm following the 10 steps instruction here, http://technet.microsoft.com/en-us/library/ms345128%28SQL.90%29.aspx, but I'm getting a lot of error when I execute the package. How can I fix this? Thanks.

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'titles' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'service_lines' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'treatment_areas' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'subspecialties' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'bio' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'educations' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'internships' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'residencies' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'fellowships' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'certifications' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'societies' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'awards' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'links' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'image_ref' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'appt_emails' is not supported.

Error at Data Flow Task [Fuzzy Lookup [1693]]: The data type of column 'keywords' is not supported.

Error at Data Flow Task [DTS.Pipeline]: "component "Fuzzy Lookup" (1693)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [DTS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

Open in new window

ASKER CERTIFIED SOLUTION