Building a meta-driven near realtime ETL solution with BIML

With the outset in a real life solution, build to one of the largest organizations in the World, this all demo session will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you. Being able to do this and have the system finding the fastest way to load data automatically using system stored procedures enables you to offer near real-time reporting to your users. Topics covered in the session:

• BIML & SSIS
• MDS
• CDC
• System SPs (especially sp_depends)
• Near Real-time ETL, what it takes and how to do it.