Perth SQL Server User Group

PSSUG is a PASS chapter run by Jenny Richardson and Cody Konior. We meet once a month to enjoy technical presentations about SQL Server over complimentary pizza and refreshments.

Whether it's your first time attending, or you just haven't been in a while, come join us! RSVP for live events at



Topic BIML for SSIS
Date Thursday, July 28, 2016 from 5:00 PM to 7:00 PM (AWST)

Harish Siani


BIML is an XML based language that allows metadata based generation of a whole BI solution. It's really powerful in automating building of ETL process using SSIS and can be used via BIDS helper, a free tool that is well known to Microsoft BI developers. Let the speaker take you on the journey from starting with BIML to having a template that can be used to automate creation of SSIS packages. We will see how it can help significantly reduce the development time for ETL process and at the same time increase quality by keeping to standard practices & design patterns.

Speaker Bio

Harish is a Business Intelligence Architect who works for P&N Bank. He has over 20 years of experience in Microsoft Technologies.  Lately he has shifted his focus on delivery of BI Solutions and has end-to-end experience across the Microsoft BI Stack. A significant part of his work involves developing database solutions and tuning SQL servers and queries. He holds a number of Microsoft Certifications, including MCSE - SQL 2014 BI and MSCA – SQL 2014.