What’s new in Data Quality Components for SSIS 8.1

What’s new:

Advisory:

DQC Components for SSIS, SQL Server 2008 is END OF LIFE support. At this time, we will no longer support 2008 SQL Server, SSIS, components will remain static. Property V3 Component is deprecated and Property V3 Components will no longer receive updated data. We will announce when Property V3 web service will be shut down at a later date. We highly recommend updating to Property V4 Component which is included in our DQC SSIS 2018 Q1 release.

New Release: Property V4 Component

Our new Property V4 components is now released. We are excited to bring new fields and data into this product over the next couple of quarterly releases. This initial release will cover almost everything that the Property V3 outputted. We will be releasing new functions and capabilities as well in the future releases.

New Update: Personator Component

Personator components received social security updates. You can now use Social Security Number as an input and receive SSN result codes back. We also included social security as an option in centric hints during processing. Additionally, we have included extra output fields in both our basic outputs and demographics output.

Added Social Security Number (SSN) Result Codes

• VR11 - Name and SSN Match - Matched the name field to the Social Security Number.
• VS50 - Last4 Only Match - The name only matched to the last 4 digits of the Social Security Number.
• SN01 - Invalid SSN Format - The format of your Social Security Number was invalid.

Added the following output fields to the Personator Demographics Output Group

• ChildrenAgeRange - Returns the age range of children present in the household.
• CreditCardUser - Returns whether the user has a credit card or not.
• Education - Returns the highest level of education completed by an individual.
• EthnicCode - Returns an individual’s specific ethnicity.
• EthnicGroup - Returns the grouped category for a person’s ethnicity.
  This is a more generalized grouping compared to Ethnic Codes.
• HouseholdSize - Returns the number of occupants in the household.
• PoliticalParty - Returns an individual’s political affiliation.
• PresenceOfSenior - Returns the presence of senior/s in the household.

Added the following output fields to the Personator Output Columns

• MelissaAddressKey - Returns a unique key associated with an address.
• MelissaAddressKeyBase - Returns a unique key associated with a building containing multiple suites/apartments.
• PhoneCountryName - Returns the full country name for the phone number entered in the Phone field.
• PhoneCountryCode - Returns the 2 character country code for the phone number entered in the Phone field.