Q:

How to update parameters in SSIS?

I would like to know if I can update the parameter values (mainly timestamp) automatically using any SQL query. Please don't suggest me to use Environments, as the value is constantly changing and I need them to be updated automatically when I run.

A:

you may follow these steps to config your parameter:

create a variable, e.g. User::starttime
add an 'Execute SQL Task':  specify the connection info and the query. e.g. SELECT STARTTIME FROM TABLE. set the ResultSet to 'Single row'. in the ResultSet Tab map the result name and variable name. 
after the 'Execute SQL Task' executed, the variable 'User::starttime' will be set to the SQL result. 
use the variable User::starttime as your parameter. 

