From the looks of things you have some kind of date value to load data for a week. In your query, rather than use a fixed date parameter like DATEADD(dd,-7,GetDate()), use a variable, probably something like DATEADD(dd,-?,GetDate()). Put the variable in a package configuration. Then when you need to run the job for a different date range you simply change the configuration value and run your package. No need to modify your package.