Skip to main content

7 docs tagged with "configurations"

View all tags

Initial Historical Load into SQL Server PDW (APS)

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.

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.

Transformer Targeting Multiple SSIS Versions

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.

Writing Custom Validators Using Biml

This walkthrough demonstrates how to create your own custom errors, warnings, and messages. It also shows how to interact with the validation system to...