SQL Server Integration Services Extensions Updates

It’s been a while since I blogged about SSIS extensions to Visual Studio. For that, I apologize. During my hiatus, The Microsoft SSIS Team appears to have separated the SSIS extensions for Visual Studio 2019 and Visual Studio 2022. The latest version of the Visual Studio 2019 SSIS extension is version 4.5, updated on my …
Continue reading SQL Server Integration Services Extensions Updates

SSIS Catalog Error 27150

In case you’ve never encountered SSIS Catalog Error 27150, the error message reads: The version of the project has changed since the instance of the execution has been created. Create a new execution instance and try again. A customer recently encountered this error. So… what happened? Short Answer The version of a project changed during …
Continue reading SSIS Catalog Error 27150

SSIS Catalog Browser v0.9.14.0 is Available

I am honored to announce the latest version of SSIS Catalog Browser is available for (free!) download. Updates in v0.9.14.0: Bug fixes. No longer mixing package parameter references with project parameter references in the Values Everywhere feature. Check it out today! Want to Learn Azure Data Factory (from me)? I’m delivering a full day of …
Continue reading SSIS Catalog Browser v0.9.14.0 is Available

Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available

I am excited to announce the availability of Deploy an SSIS Project to an ADF Azure-SSIS IR, a new Azure QuickStart course! Access the new course – along with all my recorded training for one year – by subscribing to Premium Level. Additional access options include: Azure QuickStart Premium – Access all Azure QuickStart training …
Continue reading Deploy an SSIS Project to an ADF Azure-SSIS IR Course Now Available

Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022

Update 19 Sep 2022: I communicated with the Microsoft SSIS Team. They shared they are targeting preview of VS2022 Integration Services Extension for the end of CY22. Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022. On 28 Jul 2021, the Microsoft SSIS Team released an …
Continue reading Updated SSIS Extension v4.1.2 Includes Support for Visual Studio 2022

Confidence and SSIS Catalog as Code

That’s what we sell at Data Integration Lifecycle Management Suite: confidence. Confidence There’s no substitute for that feeling of confidence when SSIS Catalog Compare is used to compare two SSIS Catalogs and the comparison yields no differences. I cannot improve on testimonies from our customers: The question of comparing a Production SSIS Catalog with a …
Continue reading Confidence and SSIS Catalog as Code

SSIS Catalog Compare Code Promotion with DILM Deployment Utility

This post is a follow-up to my recent post titled Promoting SSIS Catalog Objects Between Lifecycle Management Tiers. DILM Deployment Utility is a great way to encapsulate SSIS Catalog folders as code in sccpac files. Drop the files in a git repo, add, commit, and push, and viola, scripts for your SSIS Catalog folder(s) and …
Continue reading SSIS Catalog Compare Code Promotion with DILM Deployment Utility

Promoting SSIS Catalog Objects Between Lifecycle Management Tiers

Code promotion is essential to DevOps. One problem solved by SSIS Catalog Compare is code promotion via scripting between Development, Test, Pre-Production, and Production lifecycle management tiers*. In the video, I demonstrate: One gap (scripting all SSIS objects stored in the SSIS Catalog) in SSIS management tools shipped with SSMS. One way SSIS Catalog Compare …
Continue reading Promoting SSIS Catalog Objects Between Lifecycle Management Tiers

SSIS Catalog Compare August Sale

For the month of August 2022, SSIS Catalog Compare Enterprise Edition yearly subscription is on sale for 60% off the regular yearly subscription rate! SSIS Catalog Compare facilitates Data Integration Lifecycle Management (DILM) and DevOps with SSIS by: Comparing SSIS Catalog metadata between data integration lifecycle tiers (Development, Test, QA, Production, etc.) Promoting (deploying) SSIS …
Continue reading SSIS Catalog Compare August Sale

Using DILM Deployment Utility to Restore SSIS Catalog Folders

In this video, I demonstrate using DILM Deployment Utility 2022 – part of SSIS Catalog Compare 2022 Enterprise Edition – to restore the contents of an SSIS Catalog folder in a disaster recovery scenario. Question? Want to learn more? Please contact me. Enjoy! :{>