![]() Related Tasks For details about how to set properties of a data flow component, see. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics. Configuring the Fuzzy Lookup Transformation You can set properties through SSIS Designer or programmatically. In addition, if the Fuzzy Lookup transformation maintains the match index-that is, if MatchIndexOptionsis set to GenerateAndMaintainNewIndex-the transformation may lock the reference table for the duration of the data cleaning operation and prevent other users and applications from accessing the table. ![]() By doing this, you can prevent the lookup queries from consuming resources on the production server. If the reference table that the Fuzzy Lookup transformation uses is on the production server, you should consider copying the table to a non-production server and configuring the Fuzzy Lookup transformation to access the copy.
0 Comments
Leave a Reply. |