I have set up a data flow in SSIS 2005 which checks values from an excel source against a SQL Server query using a lookup and outputs the results to a flat file.
This part works fine. However I also want to capture the values from the lookup that did not match in a separate flat file. I have tried multiple things and I still cant capture the non-matching values from lookup (the flat file is always empty).
What am I doing wrong?
