O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required