Data Quality Services:Notice

From Melissa Data Wiki
Jump to navigation Jump to search

← Data Quality Services

Additional Returned Columns

Customers leveraging the DQS client within SSIS to consume our services may run into an issue where additional columns that are over and above the address will return in a single, large group of text data. This presents problems if one is interested in these additional fields of information, as many data columns may contain commas as well – such as Census columns, or results codes. This can break the parsing of this data. One of 3 resolutions is recommended in these cases:

  1. Use Melissa Data SSIS components which are programmed specifically to integrate with our Web services in the SSIS environment. This is often faster, and can give functionality above that of the DQS client.
  2. Use a script component within SSIS to connect to our web services or local libraries to cleanse data.
  3. Use the script component to connect to the azure service and pull back the specific columns of data.