![]() Once created, parameters can be used during package execution in much the same way as native SSIS variables. Using SSIS Parameters in Package Execution Package parameters can be found in the Parameters tab on each package. Project parameters are accessible by opening the Project.params file in the Solution Explorer, shown below. ![]() There is no functional difference between project and package parameters they only differ in scope, in that project parameters are visible to any package in the project, and package parameters are visible only within that package. Parameters can be created at the project level or the package level. I recommend you use this to fully describe the purpose of this parameter. ![]() Description (text): This optional field allows you to add a description.If you set this to true, the specified parameter must have a value provided at runtime, even if the parameter has a default value. Required (true/false): Indicates whether a value must be provided at runtime.Make sure you set this value to True for any secret value to prevent it from being stored or logged in plain text. Sensitive (true/false): Indicates whether this parameter contains a sensitive value, such as a password or private encryption key.You also have a couple of additional settings on each: The window for Parameters shows that these look a little like native SSIS variables.Īs you can see, each parameter has a name, data type, and a default value, similar to an SSIS variable. Think of parameters in SSIS as a special type of variable which can be bound to SSIS object properties. SSIS parameters are placeholders for runtime values. When SSIS parameters were first introduced starting with SQL Server 2012, many of these challenges of legacy SSIS configurations were addressed. ![]() This was even more complicated when passing a runtime value from a parent package to a child package, where there was no way to easily view or manage the runtime values inherited by the child package from the parent package.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |