Updated SSIS Extension v3.15 for Visual Studio 2019

On 16 Nov 2021, the Microsoft SSIS Team released an update to version 3.15 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019. An operative bullet for this version: SQL Server Integration Services Projects extension doesn’t support Visual Studio 2022 yet. There remains an issue …
Continue reading Updated SSIS Extension v3.15 for Visual Studio 2019

Live Online ADF and SSIS Training 29 Nov – 1 Dec

One week from today – at the time of this writing: 22 Nov 2021 – I am delivering Expert SSIS and Master the Fundamentals of Azure Data Factory training live and online! Update! For a limited time, use the discount code LimitedTimeDiscount33 to save even more! Expert SSIS – 29-30 Nov 2021 Join me 29-30 Nov 2021 …
Continue reading Live Online ADF and SSIS Training 29 Nov – 1 Dec

AndyStream for 7 Nov 2021

Frank and I are on Day 5 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – systems of execution. This morning I popped on for a few minutes to (again) share information about Enterprise Data & Analytics‘ …
Continue reading AndyStream for 7 Nov 2021

New SSIS Extension v3.15 for Visual Studio 2019

On 16 Aug 2021, the Microsoft SSIS Team released version 3.15 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning.   I am late getting this update published. Visual Studio 2019 v16.11.4 is now available… …
Continue reading New SSIS Extension v3.15 for Visual Studio 2019

Join Me for LIVE Online SSIS and ADF Training 29 Nov – 1 Dec

It’s been a while since I delivered training live and online. Let’s fix that! Join me for Master the Fundamentals of ADF and Expert SSIS 29 Nov – 1 Dec.

SSIS Framework Manager Updated

I am so excited to announce scripting in SSIS Framework Manager – a new component of the Data Integration Lifecycle Management Suite – is code complete! My first-pass testing worked really well, so I decided to go live on LinkedIn Live and demonstrate it. I practiced a few test-walk-throughs and it all worked. As is …
Continue reading SSIS Framework Manager Updated

Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

Update: Please be sure to read Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9 for important updates to the demo code. I am honored, humbled, and excited to announce the release of Building Custom Tasks for SQL Server Integration Services, 2nd Edition! In the first edition of this book, the demo task is …
Continue reading Building Custom Tasks for SQL Server Integration Services, 2nd Edition is Available

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework