What’s new in Data Quality Components for SSIS 12.4

What’s new:

---

Product Advisories

SSIS Global Verify Address On Premise Users – Global Address Object 32bit dll Deprecation - April 24th, 2023

The Global Address Object 32bit mdGlobalAddr.dll file will be deprecated on April 24th, 2023. SSIS Global Verify Address On Premise users will be directly affected and will not be able to continue using SSIS Global Verify Address On Premise option. The reason for deprecating the 32bit mdGlobalAddr.dll is due to issues encountered with backwards compatibility. As Visual Studio is a 32bit program and utilizes the 32bit directory during processing. The 32bit mdGlobalAddr.dll deprecation will directly affect functionality for SSIS Global Verify Address On Premise users. SSIS Global Verify Cloud users will not be affected by this change. For more information please visit Melissa's SSIS Wiki page:
https://wiki.melissadata.com/index.php?title=SSIS:Advisory:Global_Address_Object_32bit_dll_Deprecation

Microsoft SQL Server 2012 End of Support – Melissa SSIS 2012 Platform Deprecation - July 24th, 2023

As of July 12th, 2022, Microsoft has ended support for its SQL Server 2012 platform. This change will also end Melissa’s support for its SSIS 2012 platform. Beginning July 24th, 2023, Melissa will officially end support for the SSIS 2012 platform, which consists of Visual Studio 2010 and SQL Server 2012. We understand that performing a migration to another supported platform is a significant task. However, to maintain security standards and with the lack of support from Microsoft for SQL Server 2012, we believe it is in our client’s best interest to deprecate Melissa’s SSIS 2012 platform. For more information please visit Melissa's SSIS Wiki page:
https://wiki.melissadata.com/index.php?title=SSIS:Advisory:SQL_Server_2012_End_of_Support

SmartMover Component

SmartMover's NCOA and CCOA endpoints have been converted from SOAP to POST.

• New NCOA POST Endpoint:
  https://smartmover.melissadata.net/V3/WEB/SmartMover/doSmartMover
  
  
• New CCOA POST Endpoint:
  https://smartmovercanada.melissadata.net/V3/WEB/SmartMover/doSmartMover

SmartMover has a new field available for US records only.

NCOA Return Code: A code indicating the level of matching between the record and the NCOA Link database.

Global Verify Component

Global Verify Email offers 3 new output fields.

• DomainAuthenticationStatus: Returns security protocols used on the receiving mail server
• DomainTypeIndicator: Predicts if email belongs to a personal or business/organization email by analyzing the domain
• BreachCount: Returns the known number of breaches that this email account has been involved in
  
  

Additional information

For further information, please visit Melissa’s SSIS Wiki here.