Hi Daniel,

Thank you for your answer.

1 - But users who load data are not familiar with SSIS. It’s impossible for them to change the values of a variable in an SSIS package

2 - They asked in an automated package the loading of data for the last 6 weeks but They want to have in a table the possibility to force these dates if necessary (for example if the first load for which all chargerait the year 2012 ).

I thought the solution might be to have a table of parameters that would list every week with a column that will tell us what a week load.

What do you think?

I am waiting your answer.