Step 1: Drag and Drop the Dynamic properties in the designer

Step 2: Right click on the Designer window - > Click Package Properties -> Global Variables

i. Add Name,Type and value

Step 3: Double click the Dynamic properties which you have dragged and dropped initially. You will see

Destination Property, Source Type, Source Value

Click Add button. Go to Global Variables (where in you will see the variable you have created)

Select it and click set. YOu will see a window with a combo box source type. Select Global Variable. Then you will see the global variable you have added and finally click ok.

Double click the transformation: You will see the query something like this. Select * from customers where cust_id = ?

Click parameters and add the corresponding global variable

VIP: Make sure the dynamic properties is the first step executed in your package.

Thanks,

Ganesh

Have a nice day, unless you have other plans.