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.
Learn how to 'roundtrip' your SSIS packages between SSDT and BimlStudio, and take advantage of the extended Biml toolsets.
Binds a connection's ConnectionString property to a package variable through a property expression and pairs it with a 'ParentPackageConfiguration', so a calling parent package can push a runtime connection string into the child.
Declares two FileConnections (one for the XML file, one for the XSD schema) and binds the XSD connection's ConnectionString property to a package variable via an expression, so the schema path can be supplied at runtime.
Reduce package creation time from 15 minutes to 15 seconds using variable replacement