Skip to main content

8 docs tagged with "parameters"

View all tags

Execute Package Task with Package Parameters

Builds a parent SSIS package whose ExecutePackage task binds one of its variables to a child package parameter via ParameterBindings, then shows the child consuming that parameter as a query parameter in an Execute SQL task.

Package Parameters

Declares typed package parameters under a 'Parameters' element and references them from inside the package via '@[$Package::ParameterName]' expressions, the SSIS 2012+ replacement for older package configurations.

Referencing Project and Package Parameters

Declares two project parameters on a PackageProject and two more on the package itself, then references them from an Execute SQL task via both '@[$Project::...]' and '@[$Package::...]' expressions and via fully scoped 'TestProject1.Parameter2' and short-name 'Parameter3' parameter bindings.

SSIS Project Parameters from Biml

Why BI Developer Extensions and the earlier BimlExpress add-in for Visual Studio do not generate SSIS project parameters out of the box, and the file safety reasons behind that decision.