Globar Variable in DTS:: Urgent

[chandanmathur]

I am creating a DTS Package to copy data from text file to table, and result along with time etc has to entered in a log table created by me.

I am trying to use Global Variables for the same.. I have set the value of the global variable by going into Package Properties, but when I try to use the variable as:

update Employee_Logtable
set End_DT = getdate () ,
No_of_Rows_Loaded_by_Package = (select count (*)
from Employee_Description ) ,
Status_Message='successfull loading'
where Name_Package= ?

it is not substituting the value of ? to the global variable..

(I want something like this:

update Employee_Logtable
set End_DT = getdate () ,
No_of_Rows_Loaded_by_Package = (select count (*)
from Employee_Description ) ,
Status_Message='successfull loading'
where Name_Package= <<<MY GLOBAL VARIABLE>>>

)


I am a new user in DTS.

Can anyone please help me out. Its urgent.

[Scrotehead]

Within the DTS Click on the 'execute SQL task' Icon.
This will contain your update sql that refers to a parameter with question mark. On that same window there is a button 'Parameters'. Click that it and it opens up another dialogue. In the 'Input Parameters' tab click in the global parameters area and you should have a 'parameter 1' entry on the right hand side (that refers to your first ?).
All you have to do is select the your global parameter on the left side <<<MY GLOBAL VARIABLE>>>.