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.

[stickplayer]

Very helpful, and covered the exact questions I had, which were missed in some other videos I watched.

[MrShaarkrat]

Thanks for the explanation. I don't have the button to add parameters in the connection manager. Do you know why?

[richardedwards]

Nice clear concise tutorial, thanks!😊

[RanjithKumar-ikic]

Good one. Thanks. Can we get the parameters or variables dynamically from the database ? In my case I need to set the SourceConnection and TargetConnection dynamically from the database. Can you please suggest on this.

[zakkarchiheb]

what about an ODBC connection how can we map the parametre?

[LubaFromNY]

Thank you so much for detailed explanation!

[mandhakarthik]

How to use parameter or variable for odbc source in sql command