Business Intelligence Data Warehousing Data Integration ETL Azure Data Platform Azure Data Factory Azure Synapse Analytics Microsoft Data Platform SQL Server Integration Services SSIS Biml BimlScript Microsoft SQL Server SQL Server SQL
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!
Session Level: 100-200 / Beginner-Intermediate
Session Length: 45-75 minutes
Prerequisites: Must have experience with basic SSIS development. Should have knowledge about Data Warehousing and ETL concepts.
Cathrine loves data and coding, as well as teaching and sharing knowledge 🤓 She is based in Norway and works as a Tech Lead and Senior Data Management & Analytics Consultant in Skill, focusing on Data Integration and Data Warehousing. Her core skills are Azure Data Factory, Azure Synapse Analytics, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the Azure and Microsoft Data communities as a Microsoft Data Platform MVP, international speaker, blogger, organizer, and chronic volunteer. She blogs at cathrinew.net and tweets at @cathrinew.
Cathrine is based in Norway, but loves traveling and speaking internationally.