Variables doesn't retain values

See more:

SSIS

Hello,

I have 2 variables in my SSIS scripts which represents files names (Filename_YYYY.mm.dd.csv"). Default values provided to variable are FITA.csvI have used script task to get file name in specific format and then updates value of variables. I have used same thing to generate files which works perfect. Files are generated with correct names and format.

I have to upate records in database with respective file names. I have created stored procedure which using Execute SQL task where I am passing these two variables like

EXEC Proc_name ?,? and have mapped variable names as well. When i check records in database, I see default file name against rows. Why is it not using updated value whereas it is using same value to generate file which is correct?