Biml for Beginners: Script and Automate SSIS Development
Links:
Sign up to our Meetup group https://www.meetup.com/hybrid-virtual...
Join our LinkedIn group / 12487962
Follow us on Twitter / hybridvug
...and of course don't forget to subscribe to our channel, like the video, and hit the bell! It really helps us in our mission to produce free content for the masses.
Session Details:
Are you tired of creating and updating the same SSIS packages over and over and over again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and start automating your SSIS development?
Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.
In this session, we will first look at the basics of Biml and how to automatically generate SSIS packages from database metadata. Then we will explore techniques for reusing code and implementing changes across projects with just a few clicks. Finally, we will create an example project that you can download and start with to generate all the SQL scripts and SSIS packages needed to build a staging environment in just a few minutes.
Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!
Speaker Details:
Cathrine Wilhelmsen loves teaching and sharing knowledge. She works as a consultant, technical architect and developer, focusing on Data Warehouse and Business Intelligence projects. Her core skills are ETL, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she's active in the SQL Server and PASS communities as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.