Anatomy of a Catalog Reference Script in SSIS Catalog Compare

A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare

Anatomy of an Environment Script in SSIS Catalog Compare

An SSIS Catalog Environment script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that support SSIS Catalog Environment Variables contained within an SSIS Catalog Environment. These parameters are placed at the top of the script for …
Continue reading Anatomy of an Environment Script in SSIS Catalog Compare

Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare

An SSIS Catalog Connection Literals script is automatically generated using several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that will be used to provide literal overrides. These parameters are placed at the top of the script for easy access by …
Continue reading Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare

Surface Connections in SSIS Catalog Compare and Catalog Browser

Changing the way Connections are surfaced and managed was a major focus of SSIS Catalog Compare version 3. The changes were first shared as part of SSIS Catalog Browser – a free utility from DILM Suite for viewing the contents of an SSIS Catalog – because building the surfacing mechanisms for the SSIS Catalog was …
Continue reading Surface Connections in SSIS Catalog Compare and Catalog Browser

Lift and Shift an SSIS Catalog…

… to a different instance on-premises. … to Azure Data Factory SSIS Integration Runtime. This screenshot is from the SSIS Catalog Compare documentation. You can script an entire SSIS Catalog using SSIS Catalog Compare! This awesome functionality can save you hours (days, weeks, even!) when starting a new project or updating an existing project. This …
Continue reading Lift and Shift an SSIS Catalog…

I am a Product Manager (No, I’m Not… But I Can Explain)

I was about to click the Publish button for this post about my new role as a product manager when my friend and brother, Scott, called. I mentioned it and Scott said, “You’re not just a product manager. You’re a problem-solver.” Scott is correct. Hence the parentheses in the title of this post. “Is This The …
Continue reading I am a Product Manager (No, I’m Not… But I Can Explain)

Announcing SSIS Catalog Compare Version 3!

I’m so happy to announce the release of SSIS Catalog Compare version 3! SCCv3 Speaks Cloud In May, Microsoft announced the general availability of Azure Data Factory SSIS Integration Runtime. Customers immediately began deploying SSIS from on-premises servers to the cloud. Some quickly recognized some gaps in the process, such as: On-premises, enterprises have the …
Continue reading Announcing SSIS Catalog Compare Version 3!