Create and Load a Staging Environment from Scratch in an Hour with Biml

Speaker: Scott Currie

Duration: 60 minutes

Track: Build

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie from Varigence will use the free BimlExpress add-in for SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of *hundreds* of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

Accompanying Material

No material found.


View Recording

To access the session recording, please login or register first:

Sign In


Not a PASS member? Click here to register.

cage-aids
cage-aids
cage-aids
cage-aids