At February 25th March the 4th 2021 I’ll be giving a webinar on the MSSQLTips.com website. The topic is Integration Services. This webinar is meant as an introduction for beginners.
The abstract:
For years, Microsoft SQL Server Integration Services (SSIS) has been the tool in the data platform stack to integrate, move and transform your data. This ETL tool allows you to build data pipelines, extract data from various sources, transform it on-the-fly and write to many destinations. In this webinar, we give you a hands-on introduction to SSIS.
What to expect:* how to load data from a flat file, an Excel file or a database
* how to transform data. E.g. add a calculation, do a lookup against a reference data set, filter data and so on
* how to write data efficiently to a destination, such as a SQL Server database
We will use demos to demonstrate how you can load data into a database and by the end of the webinar, you’ll have the knowledge needed to start your first SSIS project.
You can register here.
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…