You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy Lookup
transformation.
The reference data to be used in the transformation changes with every package execution.
Common language runtime (CLR) integration cannot be enabled on the SQL Server database where the
reference table is located.
You need to configure the Fuzzy Lookup transformation in the most efficient manner.
What should you do?
A.
Execute the sp_FuzzyLookupTableMaintenanceInvoke stored procedure.
B.
Select the GenerateNewIndex option in the Fuzzy Lookup Transformation Editor.
C.
Execute the sp_FuzzyLookupTableMaintenanceUninstall stored procedure.
D.
Select the GenerateAndPersistNewIndex option in the Fuzzy Lookup Transformation Editor.
https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/fuzzy-lookup-transformation