Tag: ETL

By Posted on Posted in Podcast No Comments Tagged with , , , , ,

This weeks episode we are pleased to host Andy Leonard to discuss his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture. Although the SSIS Catalog DB is created with management studio, it does not behave like other databases.  Our conversation in this episode revolves around the catalog, SSIS packages, and some of the complexities of migrating …

Podcast Episode 79: SSIS Catalog with Andy Leonard Read more »

By Posted on Posted in Performance Tuning, SSIS Performance 2 Comments Tagged with , ,

Some of the biggest performance tuning wins that I have had over my career have been related to performance tuning queries that are being called from SSIS. So often the actual query performance gets overlooked in the SSIS environment. A few years ago I was able to tune a query that was being called from an SSIS package and reduce …

Steps to Improve ETL Performance Using SSIS Read more »