Automating Builds: Part 1 - Installation
In this first part, we will learn how to install the tools into our build environment to run automated builds using either the hadron.exe command line...
In this first part, we will learn how to install the tools into our build environment to run automated builds using either the hadron.exe command line...
In this webinar, we will introduce you to BimlStudio, BimlScript syntax, and the fundamentals required for you to follow and understand more advanced Biml topics.
Lists every base table from sys.tables and emits a per-table SSIS dataflow that pumps rows through the 'SqlServerPdwDestination' adapter, the path used for an initial historical load when migrating to SQL Server Parallel Data Warehouse / Analytics Platform System.
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.
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.
Demonstrates a Package-level transformer that injects an 'OnPreExecute' logging pattern and branches its Biml emit on 'CompilerSettings["SsisVersion"]', so the same framework template produces SSIS-2008 R2 log providers or SSIS-2012 system-variable bindings depending on the target.
This walkthrough demonstrates how to create your own custom errors, warnings, and messages. It also shows how to interact with the validation system to...