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 40% 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

Another Way to Use SSIS Catalog Compare to Migrate SSIS Catalog Folders

Update: SSIS Catalog Compare 2022 is generally available! SSIS Catalog Compare 2022 (Beta) is available at a dramatically-reduced yearly subscription rate at the time of this writing. The yearly subscription rate will increase when SSIS Catalog Compare becomes generally available (GA). Those willing to help out by testing the beta version (in Development and Test environments …
Continue reading Another Way to Use SSIS Catalog Compare to Migrate SSIS Catalog Folders

Using SSIS Catalog Compare to Migrate SSIS Catalog Folders

SSIS Catalog Compare 2022 (Beta) is available at a dramatically-reduced yearly subscription rate at the time of this writing. The yearly subscription rate will increase when SSIS Catalog Compare becomes generally available (GA). Those willing to help out by testing the beta version (in Development and Test environments only, please!) will enjoy the beta yearly …
Continue reading Using SSIS Catalog Compare to Migrate SSIS Catalog Folders

SSIS in SQL Server 2022 CTP 2.0

SQL Server 2022 Community Technology Preview 2.0 is available, and it includes the SSIS Catalog! Create an SSIS Catalog At the time of this writing, the SSIS 2022 Catalog is similar (identical, perhaps) to the SSIS 2019 Catalog. Connect to a SQL Server 2022 instance using SSMS and right-click the Integration Services Catalogs node in …
Continue reading SSIS in SQL Server 2022 CTP 2.0

SSIS Catalog Browser v0.9.10 is Available

I am excited to share the latest release of SSIS Catalog Browser, and it’s still free at DILM Suite! A feature I forgot to mention in the video is the “Check for Update” menu item: If you are running the current version – beginning in version 0.9.10.0 – clicking Help>Check for Update will display a …
Continue reading SSIS Catalog Browser v0.9.10 is Available

One Way to Create an Azure-SSIS IR in Synapse Analytics

On 17 Feb 2022, I first saw the Microsoft announcement of the public preview of Azure-SSIS integration runtimes in Azure Synapse Analytics. I blogged about the announcement in a post titled Azure-SSIS Integration Runtime now available in Azure Synapse Analytics. I am excited to share one way for you to provision an Azure-SSIS IR in …
Continue reading One Way to Create an Azure-SSIS IR in Synapse Analytics