FIX: .NET Framework error when you update the reference table of a Fuzzy Lookup transformation in SSIS

Applies to: SQL Server 2017 DeveloperSQL Server 2017 EnterpriseSQL Server 2017 Enterprise Core

Symptoms


Assume that you use the Fuzzy Lookup transformation in SQL Server Integration Services (SSIS). When you update or delete a reference table that the transformation uses, you receive an error message that resembles the following:

Resolution


This problem is fixed in the following update for SQL Server:

Cumulative Update 9 for SQL Server 2017

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the standard terminology Microsoft uses to describe software updates.