title: Using variable to assign value to where clause of lookup transformation
body: <p>I have a DataFlow Task which picks up a variable while running. This variable changes its value three times so the job has to run three times. I want to have a Lookup Transformation in the DFT that checks if the new value to be inserted already exists in the database for the value of the current variable.(I cannot create any unique key constraints in the database.)How do I make the where clause of the LookUp transformation pick up the value from the variable? I cannot use execute sql as it is restricted to Control flow tasks.</p>