SSIS - How to use variable as a source to compare with data in tables in fuzzy lookup?
<p>i have a requirement and this is my situation and idea. I have an excel file and i have extracted column header from it. For each column name it will be pass to SSIS as a variable into fuzzy lookup to determine the best matching column name in a table that available for it. My question is, can this be done? And how? Any suggestions, comments, or tips and tutorial are highly appreciated. Thank you in advance guys.</p>