How to refer a user variable in a script inside an SSIS Package [duplicate]

Question

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.

Srikar mogaliraju · Accepted Answer · 2019-04-05 12:03:38Z

2

Try this:

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

answered Apr 5, 2019 at 12:03

Srikar mogaliraju

2151 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1