In this post Andy shares thoughts about a new custom SSIS task I’ve written to set SSIS package variable values from SSIS Catalog Environment Variable values.
Tag:SSIS
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
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