SQL Server 2016 - SSIS "Fuzzy Lookup" transformation should allow NTEXT/NVARCHAR(MAX) columns to pass thru
When using the fuzzy lookup transformation in a data flow, NTEXT/NVARCHAR(MAX) columns are forbidden to simply be passed thru the transformer. We have to split the columns before fuzzy lookup and join them after sorting after the transformation. This imposes performance.
So pls. add a function to fuzzy lookup to pass thru NTEXT/NVARCHAR columns.