1

I am using an SSIS package which has variables.

I am retrieving data from a progress data base and I want to refer one of the variables I am using in the Query string to filter data.

My question is what is the syntax to be used in order to refer this variable in the progress script

I tried this syntaxe @[User::uservaraibale] found in this link but it is not working

Suppose the script is

select column1,column2 from Table where column3=@uservariable

How to refer @uservariable ?

Thank you for your help.

Hadi
  • 36,233
  • 13
  • 65
  • 124
Kemal AL GAZZAH
  • 967
  • 6
  • 15

1 Answers1

2

Try this:

Initially Set the parameter mapping and then use ? in place of variable in sql script. enter image description here

enter image description here

Srikar mogaliraju
  • 215
  • 1
  • 10