Building a meta-driven near realtime ETL solution with BIML and SSIS
Duration: 60 minutes
Track: Recommended for BI professionals
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
* System SPs (especially sp_depends)
* Near Real-time reporting, what it takes and how to do it.