Welcome to the Kansas City SQL Server Users Group
We're currently looking for feedback on a number of items from the group in order to make the meetings more beneficial to everyone. Please take a moment to fill out this survey (It should only take a minute or two).
Still have questions, please call:
Topic: Zabbix: 2012 SSIS Deployment and Maintenence
Date: April 17, 2014
Speaker: Bill Fellows
Overview: In this session, you'll learn everything you need to know to successfully deliver a modern SSIS solution. We'll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution & troubleshooting.
The 2012 release of SSIS focused on improving the management of SSIS packages - post development. This session is going to provide a walkthrough of how you're going to deploy a project to a server and use the new Environments variables to configure its execution. After passing UAT, we'll then deploy to production, migrating our change scripts, monitor package execution and learn how to troubleshoot troublesome packages without editing them.
Session Goal 1
Attendees will understand the project deployment model and their available deployment mechanisms.
Session Goal 2
Attendees will understand how to create, configure and migrate SSIS Environment variables and projects across instances.
Session Goal 3
Attendees will understand the native capabilities for monitoring SSIS package execution and the amazing new tools for natively troubleshooting a package.
Bill is a Business Intelligence expert with Valorem Consulting.
Sponsor: Valorem Conulting