In SSIS, Lookup Transformation is really an important tool. But the design of it prevents user to set the SQL statement dynamicly. In my work, I need to prepare a text file for BULK loading into table. The original csv file could be 10 million ~ 1 billion...