Build Your Extract Packages Automatically!
BI Platform Architecture, Development & Administration
Automating extract packages is trivial, you simply use INFORMATION_SCHEMA. The problem is not all your data sources have easy to read metadata like SQL Server. How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.
With that schema, automatically generating your extract package is a matter of seconds! Join me while I share my interrogator project with you and start saving hours at work today!
Before attending you should have some SSIS development experience as well as some exposure to Biml and BimlScript.