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.