Not sure I completely understand so I'm going to ask some questions.

From how I read the question, you want to take a SSRS report, replace anything in column 'x'...

Thanks Ed,

Indeed, I was hoping to do exactly what you suggest in the first option - read from a table, use the date, and update the table at the end...

Set your destination connection and db in the Data Flow container with your source connection mapped to it.

You should have a button called 'New' beside the dropdown that chooses the...