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_Logtab le
set End_DT = getdate () ,
No_of_Rows_Load ed_by_Package = (select count...