Biml for Beginners: Speed up your SSIS development

2016

TL; DR

SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.

Session Details

SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Even if you use templates and follow best practices you often have to repeat the same steps over and over and over again. Handling metadata and schema changes is a manual process, and there are no easy ways to implement new requirements in multiple packages at the same time.

It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml (Business Intelligence Markup Language) and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code.

Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!

3 things you'll get out of this session

Cathrine Wilhelmsen's previous sessions

Website Analytics in My Pocket Using Microsoft Fabric

Join this session to see how easy it is to create a pocket-sized dashboard for your website analytics. First, learn how to automatically collect statistics from an API and store it in a central location. Then, see how quickly you can visualize the data in a mobile-friendly way using Power BI. 📈

Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.

"I can't keep up!" - Turning Discomfort into Personal Growth in a Fast-Paced World

Are you struggling to keep up with all the latest product changes and new technologies? Awesome! That means you have ambitions. You can do anything if you set your mind to it. It just might not be easy. Are you ready to turn your "I can't keep up" into "I can't believe I did all of that in just one year"?

Stressed, Depressed, or Burned Out? The Warning Signs You Shouldn't Ignore

Stress barges through your door and yells "hey, it's me!", while depression and burnout silently sneak in and gradually make adjustments until one day you turn around and realize that you no longer recognize your house. What are the warning signs you need to be aware of in yourself or your loved ones?

6 Tips for Building Confidence as a Public Speaker

In this session, I share the top tips I have learned over the years. All it takes is a little preparation and practice.

Lessons Learned: Implementing Azure Synapse Analytics in a Rapidly-Changing Startup

What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?

Biml Tips and Tricks: Not just for SSIS packages!

Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.

Level Up Your Biml: Best Practices and Coding Techniques

Attend this session for an overview of Biml best practices and coding techniques. Learn how to centralize and reuse code, simplify logic, and create your own C# classes and methods. Improve your code and level up your Biml in no time!

Tools and Tips: From accidental to efficient DWH developer

As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.