Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
Tag:SSIS Catalog
Parsing SSIS Catalog Messages for Lookup Performance, v2
A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups. I’ve updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalog’s default Logging Level). Some smart data integration people recommend setting the SSIS Catalog Logging Level to Verbose and …
Continue reading Parsing SSIS Catalog Messages for Lookup Performance, v2
Coming Soon: SSIS Catalog Compare Updates
I spent a lot of time this year writing and managing a book project. I will blog about that later, I promise. While I enjoy writing it really cuts into my play time. What do I do when I play? I write software. This weekend I cracked open the code for SSIS Catalog Compare and …
Continue reading Coming Soon: SSIS Catalog Compare Updates
Catalog Reports Update
I recently updated the Data Integration Lifecycle Management Suite (DILM Suite) Catalog Reports solution! Here’s a summary of the changes: I re-arranged fields on the Executions Report: I moved the links to the Overview, Messages, and Performance reports to the left in each (execution) row to support easier navigation. I added Previous and Next Execution …
Continue reading Catalog Reports Update
A Basic SSIS Catalog Dashboard in Power BI
Announcing the latest addition to the DILM Suite: Basic SSIS Catalog Dashboard in Power BI! This free download includes a T-SQL script to create a view in the SSIS Catalog database (SSISDB) and a Power BI template for viewing SSIS Catalog executions by Year, Month, Folder, Project, Package, and/or Execution Status. The Basic SSIS Catalog Dashboard …
Continue reading A Basic SSIS Catalog Dashboard in Power BI
Updates to Integration Services Deployment Wizard
I’m doing a little writing and I noticed something different about the Integration Services Deployment Wizard. Specifically, the Select Destination page now looks like this: The Authentication dropdown – along with the User name and Password textboxes – are recent additions. I’m not sure if they’re part of the SSMS 17.2 installation or one of …
Continue reading Updates to Integration Services Deployment Wizard
Intelligent Data Integration, SSIS Design Patterns, and Biml
On occasion I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday events. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and no. It has the same title but… I’ve focused on Biml presentations for the past two years. Over the …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml
The Recording for Designing an SSIS Framework is Now Available
Kent Bradshaw and I had a great crowd, lots of awesome questions, and delivered good demonstrations at the Designing an SSIS Framework webinar. You can view the webinar for free (although registration is required) here. In the webinar Kent and I discussed the following Data Integration Lifecycle Management Suite products: SSIS Framework Community Edition – free and open source Catalog Reports – …
Continue reading The Recording for Designing an SSIS Framework is Now Available
What is the DILM Suite? 2. SSIS Catalog Compare
SSIS Catalog Compare is really two products: SSIS Catalog Compare (GUI – graphical user interface) and CatCompare (CLI – command-line interface). This post will focus on GUI functionality as it’s easier to demonstrate. SSIS Catalog Compare provides the following functionality to enterprise Data Integration Lifecycle Management (DILM): Compares the contents of two SSIS Catalog instances. …
Continue reading What is the DILM Suite? 2. SSIS Catalog Compare
Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
This post was originally shared on SQLBlog. You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you’ve been given an ISPAC file, …
Continue reading Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)