The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars.

PASS BA Conference

Be sure to use the code BAVCBI to save $150 when you register for the PASS Business Analytics Conference.

March 2015 Upcoming Sessions

Next Meeting

Tue, Apr 14 2015 19:00 Eastern Daylight Time

Automating Your SSIS Design Patterns for Faster Development


Automating Your SSIS Design Patterns for Faster Development

Once you finish designing the SSIS packages needed for your project, the process of creating those packages is mostly redundant and time-consuming. As the source or target systems go through changes (even as small as a column rename), you’re forced to modify the packages. BI Markup Language (BIML), which is a free plugin, removes the pain-points involved in manual development by programmatically generating packages. In this session, you’ll learn the basics of BIML and see how you can use it along with metadata to create packages automatically. You’ll also see how easy it is to regenerate the packages when the system changes. You’ll leave the session with knowledge of BIML’s building blocks and a principle I call “D[ee]MOB” that helps you automate SSIS development in your environment.

Sam Vanga helps business people solve their data problems and enables them make data-driven decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at


Web: | Twitter: @PASSBIVCEmail: