Categories: SSIS

Upcoming Webinar – Intro to SSIS – Advanced Topics

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.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

Recent Posts

Techorama 2024 – Slides

You can find the slidedeck for my Techorama session "Microsoft Fabric for Dummies" on github.

17 hours ago

Webinar – Microsoft Fabric for Dummies

On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about Microsoft…

3 days ago

Get row counts of all tables in a Microsoft Fabric warehouse

I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You…

7 days ago

dataMinds Saturday 2024 – Session Materials

It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of…

1 week ago

Check your regions people

Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came…

3 weeks ago

Book Review – Deciphering Data Architectures

I recently purchased and read the book Deciphering Data Architectures - Choosing Between a Modern…

1 month ago