Next Meeting

Thursday,

April

10

PASSDC Monthly Meeting

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • Language: English

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 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 Samuel:
Sam Vanga is a data professional, blogger, and presenter with experience in Microsoft SQL Server and BI stack. He specializes in data integration, dimensional design, database development, and BI modeling. He loves process automation because he is lazy, but doesn't like to admit it.

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Microsoft office in Chevy Chase. Meetings begin at 6:30pm, and typically last around two hours.

Location

Microsoft Technology Center
5404 Wisconsin Ave. Ste. 700
Chevy Chase, MD 20815
 

Travel

Metro is your friend; the Microsoft office is located above the Friendship Heights Station on the Red Line.

 

RSVP

 

 

PASSChapterLogo.jpg


Major Sponsors



Capital Personal Computer User Group ( C P C U G )


WaterOx Consulting


sql_micro_sm.gif


GEICO


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids