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 packages. Steve and I are excited to chat with our guest Andy Leonard about his thoughts on the catalog and how this feature provides some really interesting benefits for ETL architecture.
The shownotes for today’s episode is found at http://sqldatapartners.com/2017/01/17/episode-79-ssis-catalog/ and have fun on the SQL trail.