Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

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

0
lapucca
Asked:
lapucca
2 Solutions
 
käµfm³d 👽Commented:
The errors are a bit self-explanatory...  you have selected columns whose types are not compatible with fuzzy matching  = )

From http://msdn.microsoft.com/en-us/library/ms137786.aspx :

Only input columns with the DT_WSTR (unicode string) and DT_STR (ansi string) data types can be used in fuzzy matching.
0
 
Alpesh PatelAssistant ConsultantCommented:
Please check the datatype of those columns are matching or not
Uni-code, non unicode
0
 
lapuccaAuthor Commented:
Thank you
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now