Hi all,

i am now ready to move on to using SSIS to run my stored procedure that i have been asissted in building ...

I want to use 3 global variables and have them being used in a SSIS 'execute SQL task' task.

i have created the Global Variables in the package

Code:
ADPDIV
ADPMth
ADPYear
and in my execute SQL task, I have created a parameter mapping between them i have got 3 variables that i want populated:

Code:
@ADPDIV
@ADPMth
@ADPYear
i cannot work out how to get the SQL script to reference the Global variable!

i have tried the following:

Code:
SET @ADPDIV = ?
SET @ADPDIV = @User::ADPDIV
i have also tried to not do a set command but it doesnt work.

Any suggestions would be welcomed!

thanks in advance

peter