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

Update – Want to Test SSIS Catalog Compare?

SSIS Catalog Compare 2022 (Beta) is available at a dramatically reduced yearly subscription rate and is ready for testing! When SSIS Catalog Compare 2022 is released for general availability, the price will increase for new purchases. Users who purchase the beta version will enjoy the same (dramatically reduced) yearly subscription rate. If you are using …
Continue reading Update – Want to Test SSIS Catalog Compare?

SSIS Catalog Browser v0.9.12.0

When I tinker with SSIS Catalog Compare, SSIS Catalog Browser is affected. SSIS Catalog Browser is free, SSIS Catalog Compare is not free. I recently used SSIS Catalog Compare on a consulting engagement to migrate contents of an SSIS Catalog from one server to another. During the migration, I found references were not processed as …
Continue reading SSIS Catalog Browser v0.9.12.0

One Way to Set SSIS Catalog Security

This post is part of a series about SSIS Catalog Security. The other posts in this series are: One Way to Create an SSIS Catalog Read-Only Database Role One Way to Script SSIS Catalog Permissions SSIS Catalog Browser v0.9.9.3 SSIS Catalog security allows Enterprise DBAs and Data Architects to fine tune access and permissions for …
Continue reading One Way to Set SSIS Catalog Security

SSIS Catalog Browser v0.9.9.3

I am happy to announce the availability of SSIS Catalog Browser v0.9.9.3. SSIS Catalog Browser is free. You are welcome. This post is part of a series about SSIS Catalog Security. The other posts in this series are: One Way to Create an SSIS Catalog Read-Only Database Role One Way to Set SSIS Catalog Security …
Continue reading SSIS Catalog Browser v0.9.9.3