SSIS Parameters and Variables | connection strings and sql command
We review how to use parameters to make the connections manager settings dynamic. We also use a source query to show how a variable (parameter) can dynamically be assigned to change the source records in the sql query.
https://www.dbtales.com