Introduction

Data transfer packages should be robust in design. There are times that a package can get values from outside and set some ETL parts based on input variable. You learned how to create dynamic SSIS packages in the previous chapters, but to run a package dynamically, you may need to pass some values from outside of the package. Package parameters provide a way to get values from outside of the package. With changing parameter values, the package doesn't need to recompile.

Parameters differ from variables. Variables are designed to work inside the package but parameters are designed to get values from outside. Parameters are only available in new Project Deployment Model.

Legacy Package Deployment Model used package configuration for inter-relation between SSIS packages. As the legacy deployment model is in use in many environments, we will discuss related topics of this method and take a look at the package configurations and their differences in this chapter.

An SSIS package needs...