Parameters: Passing values to packages from outside

Packages need to be configurable from outside. Different environments may need different configuration for executing SSIS packages. Parameters are designed to get values and configuration from outside of package, and their main benefit is that they can be configured after deployment, so there will be no need to compile the package after changing the parameter's values.

Parameters can be used within SSIS packages in expressions or as variables, but don't use them counterproductively. Variables are designed to pass values inside package, and parameters are designed to pass values from outside of package.

SSIS Catalog has the ability to pass parameter values with predefined configuration which is called environment. Environments are designed to add multiple configurations and use them as needed.

In this recipe, we will create a data transfer scenario to log all tables' name and number of rows into a database table. We will create two packages...