www.sqlpass.org    Professional Association for SQL Server

Welcome back to a new year of Triad SQL PASS BI! Starting with our April meeting we will be at the new Inmar location in the Innovation Quarter in downtown Winston-Salem.

The Triad SQL Business Intelligence Users Group is a forum where any one interested in the Microsoft business intelligence stack meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by Microsoft BI professionals for the benefit of anyone interested in participating in the group.

All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every month, unless otherwise noted. Pizza and drinks are provided.
Please register on this site to be included on the latest newsletter and emails announcing our next meetings.
 February Meeting
Triad SQL BI User Group
Monthly Meeting

April 29, 2014 Meeting

Topic: Create and Load a Staging Environment from Scratch with Biml


Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this presentation, the free BIDSHelper add-in for BIDS and SSDT will be used to introduce Biml, and use it to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Paul will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of target table creation scripts, data load packages, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.


Speaker Bio: 

Paul S. Waters has almost 20 years of experience working in IT-related fields. Over half of that time, he has focused on designing and implementing data warehouses and business intelligence systems. Paul is the President of the SQL Server Innovators Guild in Greenville, SC. He was the Technical Editor for the book "Microsoft SQL Server 2008 Integration Services Problem-Design-Solution" and contributed to the Wrox book "Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports."


We are very thankful to have our sponsors Inmar and DataMasters.

RSVP: triadsqlbi@gmail.com

When: April 29th, 2014 - 6:00 PM Pizza; 6:30-7:45 Meeting

615 Vine St.
Winston-Salem, NC 27101

View Larger Map

Other News:

  • We are always looking for speakers. If you would like to present or suggest a topic, please send us an email. 

Katherine Fraser, Co-Chapter Lead
Doug PurnellCo-Chapter Lead


Our mailing address is:

TriadSQL c/o Katherine Fraser

7815 National Service Rd. AP6-44

Greensboro, North Carolina 27409

Copyright (C) 2014 TriadSQL All rights reserved.




The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.


Please visit our sponsors at: