Would you like to learn more about Data Integration Lifecycle Management (DILM) or DevOps for SSIS? Enjoy this short video describing SSIS Catalog Compare‘s comparing, scripting, and deployment support for SSIS Catalog artifacts: To learn more, contact us.
Category:SSIS
SSIS Script Error: Cannot Load Script for Execution
If I had a nickel for every time I’ve encountered “Cannot load script for execution,” I’d have a lot of nickels. In this short (7:24) video, I demonstrate the issue and my fix: My Fix For me, the fix is almost always setting the SSIS project’s TargetServerVersion property to the proper version: “Andy, How Did …
Continue reading SSIS Script Error: Cannot Load Script for Execution
New SSIS Extension v3.13.1 for Visual Studio 2019
On 12 Apr 2021, the Microsoft SSIS Team released version 3.13.1 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. On 24 Apr 2021, the Integration Services extension was updated. The page displays this information …
Continue reading New SSIS Extension v3.13.1 for Visual Studio 2019
Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9
Things change. Things change in software. Things change regularly in software. If you take nothing else away from this post, please take those nuggets of wisdom. Last week, my latest book – titled Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, (Second Edition) was …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9
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
SSIS Framework Manager CE Version 0.3 is Available
I made a few more changes to SSIS Framework Manager CE (Community Edition). The latest change is to add fields to specify the Database and Schema names. A customer shared that their enterprise considers the SSIS Catalog database – SSISDB – a system database (which I totally understand). At their request, I built a new collection of …
Continue reading SSIS Framework Manager CE Version 0.3 is Available
Updates to the SSIS Extension for Visual Studio 2019
On 25 Jan 2021, the Microsoft SSIS Team released version 3.12 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 that users rollback to v 3.11.1. The warning was issued 31 Jan 2021 and reads: …
Continue reading Updates to the SSIS Extension for Visual Studio 2019
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