Tulsa TechFest 2015
Bill Fellows, Microsoft SQL Server MVP, BI Lead, OpportuneTech
Bill Fellows is a Microsoft SQL Server MVP and leads the Business Intelligence practice at OpportuneTech in Kansas City, Missouri. He's been focused on data integration, database design and development since 1999. He is the organizer of the Kansas City SQL Saturdays and a regular speaker at SQL Server community events.
An introduction to Biml
This session is designed for you, the experienced SSIS developer who's been hearing about the Business Intelligence Markup Language, Biml, but has not taken the plunge. We will cover what the Biml language is and how using your familiar development tools, SQL Server Data Tools, SSDT, and BIDS Helper, you will be able to streamline the creation of SSIS packages. We will work through progressively more complex examples from a "Hello World" equivalent to a to a full fledged, audited, truncate and reload pattern.
You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.
An introduction to SSIS
SQL Server Integration Services, SSIS, is a native Extract, Transform and Load, ETL, technology that is built into SQL Server. This session is perfect for the novice developer: we'll walk through some common problems that people solve with SSIS and how you implement them.
SSIS Project Deployment Model: Deployment and maintenance
In this session, you'll learn everything you need to know to successfully deliver a modern SSIS solution. We'll cover the mechanics of building our porject; deployment; creation, configuration and migration of Environment variables; monitoring execution & troubleshooting.