The PASS Hybrid VG aims to cover all technologies and solutions that may be integrated with (or used alongside) the MS Technology stack, in order to complement or improve existing solutions.

Login to Subscribe

Upcoming Sessions

To join our next session, click on the "Register" button.
Biml for Beginners: Script and Automate SSIS Development

Mon, Jul 30 2018 18:00 UTC

Biml for Beginners: Script and Automate SSIS Development

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!


Cathrine Wilhelmsen

Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, 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 community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.

Announcements

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids