SSIS Parameters in Different Type of Data in Package

How can I image that parameters in SSIS that quite different when you have to use it in different type of data flow. Yes I know that at first we have to create parameters in same level but when you have to select data by use different type of database you have to change the syntax for query, OKEY! let's see what is different.

Set Parameter for Execute SQL Task Step 1

STEP-1
You have to create parameters as below by click on menu  SSIS -> "Variables"

STEP-2
Define parameters as you want for example, year, month etc..

STEP-3

After you created and define all parameters as you want you have to set parameter for "Execute SQL Task", you have to set type of parameter as your data config on table of database

STEP-4

Then click on query of Task and you have to replace the value of parameter by use =? instead

STEP-5

But if you have to put parameter on "ADO Net Source" object, you have to replace it by =@parameter_name

Set Parameter for Execute SQL Task Step 2

STEP-6

Any if you have to use "Execute SQL Task" in same package and need to set parameter, you have to add parameter in that task again

STEP-7

After you set parameter on this step, you have to replace parameter by use "=?" in "Execute SQL Task" it the same as step 1

STEP-8

To use parameter for query on OLE DB you have to click on "Parameters" button on the right page of window popup

STEP-9

And now you have to replace parameter on OLE DB for query data from SQL Server as
"=?"

STEP-10
It's perfect your job package will look like this image, click on "Start" for running package

Notice :
Define parameter for a package you have to set it just one time but for use parameter in different type of object, you have to replace in different symbol.