Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: ssis

Speaking at Data Saturday Rheinland – Migrating SSIS to ADF

February 24, 2023February 24, 2023 Koen Verbeeck Leave a comment

I’m pleased to announce that I’ll be talking about how you can migrate your SSIS skills to Azure Data Factory at Data Saturday Rheinland. At the time of writing this post, the schedule isn’t online yet, but I assume it will be up shortly. The abstract for my session: Integration Services is the new Cobol. […]

Read More

Build Once – Add Metadata (the importance of metadata-driven frameworks)

February 13, 2023February 20, 2023 Koen Verbeeck 4 Comments

When working in business intelligence, data engineering or data in general, there are some “mantras” that are being adopted by the larger community as “best practices”. For example, I shout “STAR SCHEMA ALL THE THINGS” anywhere I can, because a star schema is the most optimal way to design your model in Power BI. We […]

Read More

Speaking at Data Community Austria Day 2023

January 9, 2023January 13, 2023 Koen Verbeeck Leave a comment

Let me start by wishing everyone the best for the year 2023! We’re going to kick off the new year with a virtual conference: the Data Community Austria Day 2023. I’m going to present the session Migrate your SSIS skills to ADF. You can find the schedule with all the abstracts on Sessionize. Hope to […]

Read More

User Group Meeting – Migrate your SSIS skills to ADF & More

November 30, 2022December 5, 2022 Koen Verbeeck 4 Comments

This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be two sessions: It’ll be a very interesting evening, and catering is provided. For registration and practical details, check out the dataminds website. I’ve uploaded my slidedeck to Github.

Read More

How to Install Integration Services 2022

November 25, 2022November 25, 2022 Koen Verbeeck Leave a comment

The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022. SSAS and SSRS have been available for some time now in VS 2022, but the extension for SSIS has only just been released in preview. For those […]

Read More

Speaking Engagements for Fall 2022

August 23, 2022August 23, 2022 Koen Verbeeck Leave a comment

The summer holiday is almost over, and this means conference season will be back in full swing again. I’ll be speaking at a couple of events in the second half of this year: Data Bash. A new free virtual conference focusing on the German-speaking nations in Europe. And on data of course. There are sessions […]

Read More

Book Review – Azure Data Factory by Example

March 29, 2022March 29, 2022 Koen Verbeeck 2 Comments

I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book was not exactly what I was expecting, but that’s actually my fault and not the book’s. The book itself is great and is a great introduction to Azure Data Factory (ADF) and it covers almost […]

Read More

Webinar – Improve SQL Server Data Quality in SSIS

September 20, 2021September 20, 2021 Koen Verbeeck Leave a comment

On the 5th of October 2021 I’ll be giving a webinar about improving data quality of contact data (names, addresses, emails etc) using the Melissa Data Tools. I’ll be doing half an hour of technical demos, while Jeremy of MSSQLTips.com will take for another half our of the business value of the Melissa software. Data […]

Read More

Upcoming Webinar – Intro to SSIS – Advanced Topics

June 19, 2021June 19, 2021 Koen Verbeeck Leave a comment

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 More

SSIS and the “ORA-00907: missing right parenthesis” error

March 4, 2021March 4, 2021 Koen Verbeeck Leave a comment

I had the extreme pleasure recently to extract some data out of an Oracle database. I wrote the source query in Toad, where it executed successfully. I created my SSIS package, added the dataflow and an OLE DB Source component. I copy pasted the query into the editor and tested it using the preview. Which […]

Read More

Posts pagination

1 2 … 6 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress