March 2015 Upcoming Sessions
Tue, Apr 14 2015 19:00 Eastern Daylight Time
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 http://SamuelVanga.com.
Web: http://Bi.sqlpass.org | Twitter: @PASSBIVC | Email:
PASS DW/BI VC YouTube Channel
Our meetings share solutions/experiences with data warehousing, multidimensional modeling, ETL, Microsoft BI platform and the latest news/topics in the BI industry.
Interested in volunteering or speaking for the BI / DW Chapter?