Next Meeting: Thu, Aug 04 2016
August 4th Meeting
Event Type: In-Person
Online Meeting URL: None
Join us for a PASS Summit 2015 session "2014 SSIS Project Deployment Model: Deployment and Maintenance"
UTC : Thu, Aug 04 2016 23:30 - 01:00
Event Time : Thu, Aug 04 2016 18:30 - 20:00 Central Daylight Time
Your Local Time: Thu, Aug 04 2016 23:30 - 01:00
2901 S 84th St #16
Direction: Dino's Eastside Grille located on the SW corner of 84th and Van Dorn
2014 SSIS Project Deployment Model: Deployment and Maintenance
Bill Fellows, BI Solutions Consultant Blue Granite
The 2014 SQL Server Integration Services (SSIS) Project Deployment Model introduces new opportunities for the delivery of SSIS solutions. Gone are decisions about logging providers, configuration approaches, and deployment targets. Now, you need to focus on the creation of an .ispac, the approaches to deploying the project, and applying configurations to ensure expected behavior.
This session begins by exploring mapping between elements in an SSIS project and their counterparts in the compiled file, the .ispac. The session then covers three approaches for automating the deployment of this unit into SSISDB We then cover the administration side of the SSIS Catalog. You create SSIS environment variables and apply them to configure run-time behaviour. Finally, you work through the native tooling to troubleshoot failed SSIS packages. We'll cover SQL Server Management Studio (SSMS) reports, Catalog views, and data taps for run-time collection of values.
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City's seven SQL Saturdays and a speaker at many other SQL Saturdays and User Groups.