Author:Andy Leonard

The recordings for SSIS Academy: Using the SSIS Catalog, Day 1, Day 2, and Day 3 are now available (registration required)! Day 1 focused on creating the SSIS Catalog and SSIS deployment. [Note: Video is missing for the first 4:15 of this recording.]Day 2 focused on SSIS Execution and Monitoring Wednesday. SSIS Configuration was the topic …
Continue reading The Recordings for SSIS Academy: Using the SSIS Catalog are Available

Kent Bradshaw and I are delivering a series of webinars 27-29 Dec 2016 called SSIS Academy: Using the SSIS Catalog. Why? We’ve been using the SSIS Catalog in Production since 2012. We’ve learned a lot about how it works. Some parts of the SSIS Catalog are complex and we want to share – as best …
Continue reading Three Free Webinars About Using the SSIS Catalog

Click here for an overview of updates included in SQL Server vNext CTP 1.1 and click here to download the bits for Windows. :{>

This post is inspired by Kenneth Fisher’s [blog | @sqlstudent144] post, An interview with me. Ken suggested, “Now if any other bloggers read this and feel like answering questions too I’d love to read them so make sure you put a link to your blog down in the comments below.” I’m in! 1. What are …
Continue reading An Interview With Me

As I type, SQL in the City Streamed is running on another monitor, and Alex Yates [DLM Consultants | @_AlexYates_] is screaming (almost), “Don’t do that!” I know a lot of data professionals. I know some of you read this blog. And I know some of you who read this blog are concerned about Database …
Continue reading DLM (Database Lifecycle Management)

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, environment variable values, references, reference mappings, and …
Continue reading SSIS Catalog Browser Update

An updated version of SQL Server Management Studio (SSMS) for SQL Server 2016 (v16.5.1) is now available. :{>

Update: The Recordings for SSIS Academy: Using the SSIS Catalog are Available  Join Kent Bradshaw and me for three free webinars about the SSIS Catalog! SSIS Academy: Using the SSIS Catalog is Tuesday – Thursday, 27-29 Dec 2016. Attend and learn how to: Deploy an SSIS Project Execute one or more SSIS packages Monitor execution results …
Continue reading Learn More About 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 good article …
Continue reading Broken References in the SSIS Catalog

Public Failure and Humiliation I delivered an SSIS Academy presentation yesterday, the first of many (I hope). You can view the recording here (free, but registration required). If you watch around the 57:30 mark, you will notice I encounter a bug in SSIS Catalog Compare around 59:15. My subsequent demo of CatCompare – the command-line …
Continue reading A Tale of Software Development, Testing, and Demos