Thom A wrote:
You'll need to add the value of the variable first as a column, using a Derived Column Transformation (Like I showed in your other topic). Then, instead of the variable reference that (new) column.
Sorry I didn't understand your reply. Is it possible to use an alternate to Lookup transformation in this case ? Thanks.
To do what? You haven't stated what you're trying to achieve here with the Lookup Transformation, just that you want to use a variable's value within the lookup tranformation. If you're trying to lookup a value, then a Lookup is the correct transformation.
What didn't understand about my reply? I'm afraid I don't really know how I can make it much clearer, as my other post covers how to use a Dervived Column Transformation, and if you don't know how to reference a column, then the problem is far more fundamental.
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.