SQL Server 2012 redefined how SSIS packages are stored and executed. The advent of the SSISDB catalog gives a central point for working with SSIS projects deployed to the server. From this catalog we can set project and package parameter, configure environments, and monitor execution. There is no need to build in package logging because Microsoft had done it for us. This presentation covers what is in the catalog, how to deploy packages, environment, tips and tricks as well as monitoring package execution.
Stan Geiger has over 25 years experience with databases. He has been in various roles such as BI Architect, Data Architect and developer. Stan has designed and built large scale data warehouse and multidimensional cube installations in various industries such as finance, healthcare, energy, and DOD. He is currently Product Manager for the Business Intelligence products at Idera.