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 » DevOps » SSIS Administration   (RSS)
Showing page 1 of 2 (15 total posts)
  • An Example of Data Integration Lifecycle Management with SSIS, Part 2

    In this post I will demonstrate how to use the SSIS Catalog to execute and monitor an SSIS project. Manual SSIS Package Execution in the SSIS Catalog To execute an SSIS Package manually using the SSIS Catalog, connect to the SQL Server instance that hosts the Catalog using SQL Server Management Studio (SSMS). Once connected, open Object Explorer ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 15, 2017
  • 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
  • An Example of Data Integration Lifecycle Management with SSIS, Part 1

    In this post I will provide some details about the demo SSIS project. I will then focus on version control and deployment. What DILM Is and Is Not Data Integration Lifecycle Management (DILM) is not about data integration development. DILM is about everything else: Configurations Management Version Management ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 8, 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
  • Free Webinar–Advanced SSIS Execution–24 Jan 2017

    Join Enterprise Data & Analytics for Advanced SSIS Execution, a free webinar starting at 1:00 PM EST 24 Jan 2017! Kent and I demonstrated how to use the SSIS Catalog in the SSIS Academy series (see links to the recordings in the Learn More section). In this webinar, we share several ways to execute SSIS packages. Register ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 3, 2017
  • An Example of Data Integration Lifecycle Management with SSIS, Part 0

    What is Data Integration Lifecycle Management (DILM)? Here’s one way to think about DILM: Data Integration Lifecycle Management (DILM) is applying software Application Lifecycle Management (ALM) best practices to Data Integration development and operations (DevOps), version control, release management, and configuration. I can hear you ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 1, 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
  • 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
  • Data Integration Lifecycle Management (DILM) with SSIS Catalog Compare: SSIS Catalog Environments

    Have you ever tried to move some (or all) of the contents of one SSIS Catalog to another? Deploying an SSIS Project to a different SSIS Catalog is straightforward: Execute the ISPAC file, configure the new SSIS Catalog as the target, click a few times, and Boom; done. What about the rest of it? I can hear you thinking: “What Rest Of It, Andy?” ...
    Posted to Andy Leonard (Weblog) by andyleonard on August 5, 2016
1 2 Next >
Privacy Statement