Ssis: Dynamic Lookup Query

I would like to implement the following logic to my Lookup query as an expression: SELECT ID, CASE @[User::ConnectionStringID] WHEN 1 THEN 'NE' WHEN 2 THEN

Solution 1:

Lookup control has expressions, but cannot accessed directly from it just go to your Dataflowtask properties and access the expressions like shown in the image below