One of my favorite SSIS questions: Is it possible to use a lookup transform when the source are both flat files, and we do not have staging tables to dump these data, in SSIS 2008?
YES. It is possible, make use of cache transform, and then in look up task use this Cache connection instead of OLEDB Connection.
And the next question would be ..... Why do we then have Merge Join?
SQL Server Interview Questions · · · ·