On July the 22th at 9PM CET I will give the second part of the “Introduction to SSIS” webinar series on the MSSQLTips.com website. If you’ve never worked with SSIS before, it helps if you’ve seen part 1. The abstract:
In this webinar, we build upon the Getting Started with SSIS webinar. You already know how to read data from flat files and Excel, and you already know how to write to SQL Server. This time, we go one step further and introduce you to more advanced development concepts of SSIS.
We will cover these topics and more:
* using variables, parameters and expressions to make your packages more dynamic
* how to loop over items
* design pattern to load a slowly changing dimension of type 2
* expanding SSIS with .NET script tasks
* how to debug your package
In this webinar you’ll learn how to take your SSIS packages to the next level. We assume you have basic knowledge of developing SSIS packages in Visual Studio.
You can register here.
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified:…
When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse, a…
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…