THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SSIS Catalog   (RSS)
Showing page 2 of 5 (45 total posts)
  • Free Webinar 28 Mar at 1:00 PM EDT - DILM with Catalog Compare

    Join me 28 Mar 2016 at 1:00 PM EDT for DILM with Catalog Compare - another (FREE!) webinar from Enterprise Data & Analytics! DILM (Data Integration Lifecycle Management) is how data integration is done in the modern DevOps enterprise. Join Andy Leonard, Data Philosopher at Enterprise Data & Analytics, for a look at a helpful and exciting ...
    Posted to Andy Leonard (Weblog) by andyleonard on March 8, 2016
  • Deploying a Single Package First in SSIS 2016

    I gathered recently with some friends who are geeks to discuss geeky stuff. As is often the case, there were a lot of “what if” questions, and we answered most of them by firing up laptops and VMs for testing. I had some trouble with my VM running my instance of the December preview running in Visual Studio 2015 on Windows Server 2016 Technical ...
    Posted to Andy Leonard (Weblog) by andyleonard on January 21, 2016
  • SSIS Catalog Compare and DILM Recording is now available!

    You can now view the recording from the SSIS Catalog Compare and DILM presentation here. I’m trying something new here, so please bear with me. This link takes you to a registration page. After you register, you can view the recording. Enjoy! :{>
    Posted to Andy Leonard (Weblog) by andyleonard on December 30, 2015
  • SSIS Design Patterns and BIML: A Day of Intelligent Data Integration

    I’m honored to deliver a brand new precon (the PowerPoint slides still have that new slide smell) at SQL Saturday #477 – Atlanta – BI Edition! The precon is titled SSIS Design Patterns and Biml: A Day of Intelligent Data Integration. Abstract Join Andy Leonard, founder of Enterprise Data & Analytics, SSIS coach and trainer, author, and ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 21, 2015
  • Announcing SSIS Catalog Reports v0.1

    I’ve released a (very early) version of SSIS Catalog Reports – v0.1 – on GitHub. You can access the project here. My main goal is to provide some visibility into the SSIS Catalog without the need for SQL Server Management Studio. “Why, Andy?” I’m glad you asked. In some enterprises, there may be: Operations people monitoring data ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 10, 2015
  • Managing SSIS Catalog Project Parameter Values

    One of the coolest features of the SSIS Catalog is Catalog Environments. Catalog Environments offer a compelling and rich solution for Catalog Project Parameter value externalization and configuration management, whether the parameters are connections or parameter values. Configuring and using Catalog Environments involves four steps: ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 18, 2015
  • Precon - SSIS Design Patterns and BIML: A Day of Intelligent Data Integration–8 Jan 2016, Alpharetta Georgia

            I’m excited to announce I will be delivering a precon 8 Jan 2016 in Alpharetta Georgia for SQL Saturday 477 – Atlanta BI Edition titled SSIS Design Patterns and BIML: A Day of Intelligent Data Integration! This precon is all about DILM (Data integration Lifecycle Management). Abstract: SSIS Design ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 12, 2015
  • SSIS 2016 Supports Single-Package Deployment

    One of the most anticipated features of SQL Server 2016 Integration Services (SSIS 2016) is support for deploying a single SSIS package from an SSIS project. “Why Is This A Big Deal, Andy?” I’m glad you asked. Consider the following scenario: You deploy version 1 of an SSIS Project containing 20 SSIS Packages to Production. ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 5, 2015
  • The SYNCHRONIZED SSIS Execution Parameter

    I was reminded today (again) that I need to blog about the SYNCHRONIZED SSIS execution parameter. I mentioned it last week while presenting at the PASS Summit 2015 and made a mental note to blog soon. Earlier today, as I was discussing features of the SSIS Catalog Compare utility, the topic came up again. Credit where credit is due: I first ...
    Posted to Andy Leonard (Weblog) by andyleonard on November 4, 2015
  • Browsing the Catalog with SSIS Catalog Compare

    One neat feature of SSIS Catalog Compare is the Catalog Browser. It’s a TreeView control that connects to the SSIS Catalog and displays handy information for Data Integration Administrators and Release Configurations people working in a DevOps enterprise. The Integration Services Catalogs node in SQL Server Management Studio’s (SSMS) Object ...
    Posted to Andy Leonard (Weblog) by andyleonard on October 21, 2015
Privacy Statement