PASSDC Monthly Meeting

Our regular meeting! In addition to our featured speaker, we're looking forward to hearing from you about how best this user group can support professionals in the DC area. We'll also have food and raffle of a few things at the end!

**Announcing Office Hours **

Come buy a drink and participate in a SQL discussion group with Chris Bell and others.

We will head over to the Capital Grille (https://www.thecapitalgrille.com/pages/locations/?id=8041) after the meeting for about an hour of a casual open SQL discussion. The topic is not set, but feel free to bring any questions you have, or topics of interest.

Featured Presentation:

Automating Your SSIS Design Patterns For Faster Development

Samuel Vanga, SQL Server and BI Developer Fidelity & Guaranty Life

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.

About Sam:
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 (http://samuelvanga.com/).