Lincoln SQL Server User Group

Lincoln SQL Server User Group

Welcome to the Lincoln, NE Local PASS Group


Follow us:  

Click here to learn more about our group and how to attend meetings.

Next Meeting: Thu, Aug 04 2016

August 4th Meeting

Language: English
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

Lincoln, Nebraska

Direction: Dino's Eastside Grille located on the SW corner of 84th and Van Dorn

Featured Presentation

2014 SSIS Project Deployment Model: Deployment and Maintenance

Speaker: Bill Fellows, BI Architect Sterling Data Consulting

Summary: 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.

About Bill: 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 eight SQL Saturdays and a speaker at many other SQL Saturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.




PASS Summit 2020 November 10th - November 13th 2020 in Houston, TX

SAVE $150 by using discount code TBD.

Join over 5000 SQL Server and BI Professionals at the Summit.


PASS Summit brings you over three days of inspiring, jam-packed educational opportunities focused on the Microsoft Platform, professional connections, and new skills and know-how you can put to use immediately.








TEK Systems


Back to Top