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
Tag:SSIS
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
Get Started with COZYROC Cloud
My friends at CozyRoc are introducing CozyRoc Cloud, a new way to execute SSIS packages in the cloud. I was honored to test drive this new offering and captured the following short (~2:30) video about getting started. Enjoy! For more information, please visit CozyRoc Cloud! :{>
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
SSIS 2019 Extension v3.11.1 Now Available
The Microsoft SSIS Team released an update to version 3.11 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11.1 (Current Version): Release Date: December 28th, 2020 Build Version: 15.0.2000.150 Tested against Visual Studio 2019 16.8 Bug fixes: Fixed an issue that …
Continue reading SSIS 2019 Extension v3.11.1 Now Available
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS