THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSIS Catalog » SSIS Catalog Compare   (RSS)
Showing page 1 of 2 (12 total posts)
  • The Recording for SSIS Catalog Management is Available

    The recording for the Enterprise Data & Analytics webinar titled “SSIS Catalog Management” is now available (registration is required). In the SSIS Academy: Using the SSIS Catalog series, Kent and I walked through the SSIS Catalog functionality built into SQL Server Management Studio (SSMS). This webinar picks up where SSIS Academy: Using the ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 11, 2017
  • Announcing SSIS Catalog Compare and CatCompare Version 2

    I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If you’re interested in learning more about the functionality provided by the products you can ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 6, 2017
  • SSIS Catalog Browser Update

    SSIS Catalog Browser has been updated! Catalog Browser is part of the DILM Suite of utilities designed to assist enterprises with Data Integration Lifecycle Management (DILM). And it’s free. Catalog Browser provides a rich view of SSIS Catalog contents, configuration, and metadata. The utility surfaces properties, environment variables, ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 12, 2016
  • Broken References in the SSIS Catalog

    It’s possible to create a broken reference in the SSIS Catalog. What’s a “broken reference?” Let’s begin by explaining SSIS Catalog References. I wrote a lengthy explanation of SSIS Catalog References and Environments in SSIS Catalog Environments – Step 20 of the Stairway to Integration Services at SQL Server Central. Microsoft has a ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 6, 2016
  • Coming Soon: A Command-Line Interface for Managing SSIS Catalogs

    I’m excited to announce CatCompare – a command-line interface (CLI) for SSIS Catalog Compare – is in pre-release testing. I plan to release the next update of SSIS Catalog Compare with an option to purchase the GUI product stand-alone or the GUI + CLI for a higher price. BUT… If you purchase SSIS Catalog Compare before that release, you can ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 11, 2016
  • Announcing SSIS Catalog Compare v1.0

    We’re proud to announce the release of SSIS Catalog Compare v1.0! SSIS Catalog Compare compares the contents of two SSIS Catalog instances, surfacing SSIS project-related configurations metadata in treeview controls. Data Integration Lifecycle Managers, DevOps personnel, and configuration and release managers can script configurations metadata ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 29, 2016
  • Updates to SSIS Catalog Compare (Preview)

    The launch of SSIS Catalog Compare is approaching. If you purchase the beta (or preview) version before the v1.0 product launch for $95 USD, you will enjoy lifetime updates of the product and no yearly maintenance fees for support, updates, and upgrades. If you wait, you will have to pay more for the product and you will have to pay a yearly ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 21, 2016
  • Use Catalog Compare to Migrate to the SSIS 2016 Catalog

    I recently tried to use the SSISDB Upgrade Wizard to upgrade a restored SSISDB (backed up in an earlier version) to SQL Server 2016. It didn’t go well. I decided to use SSIS Catalog Compare to generate the scripts and ISPAC files from the previous instance, and deploy them to the SSIS 2016 Catalog. “You Can Do That?” Yes. Yes you can. Here’s ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 7, 2016
  • (Attempting to) Upgrade the SSIS Catalog to SSIS 2016

    A couple people have asked me about upgrading the SSIS Catalog from previous versions to SQL Server 2016 so I decided to blog about it. The SSIS Catalog is an SSIS Execution Framework that ships with SQL Server versions starting with 2012. To execute SSIS packages using the Catalog, the SSIS project must be built using the Project Deployment ...
    Posted to Andy Leonard (Weblog) by andyleonard on July 7, 2016
  • Migrating SSIS Projects and Parameters, Part 1 is Live at SQL Server Central!

    Have you ever moved an SSIS project from one SSIS Catalog to another? With Catalog Environments and References? If you haven’t, you may be in for a surprise when you try. First, why should you try? “SSIS is software development.” – Andy, circa 2008 Best practices for software development apply to SSIS. One of those practices is: Never ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 21, 2016
1 2 Next >
Privacy Statement