8 docs tagged with "parameters"

Generate the Project.params file for an SSIS Project Deployment model project from Biml by writing the parameter XML directly to disk during build.

Define SSIS variables in Biml at different scopes and reference them from tasks and parameters within their containing scope.

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.

Define an Execute SQL Task in Biml that calls a stored procedure and captures the procedure's RETURN value into a package variable.

Generate a master package and a child package with Biml that share an audit run id and a child execution id through parameter bindings.

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.

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.

Why BimlExpress and BI Developer Extensions do not generate SSIS project parameters out of the box, and the file safety reasons behind that decision.