var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: using global variables within a SSIS execute SQL task
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
and in my execute SQL task, I have created a parameter mapping between them i have got 3 variables that i want populated:
i cannot work out how to get the SQL script to reference the Global variable!
i have tried the following:
i have also tried to not do a set command but it doesnt work.
SET @ADPDIV = ?
SET @ADPDIV = @User::ADPDIV
Any suggestions would be welcomed!
thanks in advance