The Triad SQL Server Users Group (TSSUG); is a forum where Microsoft SQL Server database administrators and developers meet to learn more about the product, share ideas and make contact with other similar individuals. Our group is run by SQL Server professionals for the benefit of anyone interested in participating in the group.
All of our meetings are free and open to anyone who is interested in sharing their knowledge of SQL Server. Our meetings are generally held on the last Tuesday of every other month, unless otherwise noted. Pizza and drinks are provided.

Next Meeting: Tue, May 27 2014

Shannon Lowder presents SSIS and Powershell

Language: English
Event Type: In-Person
Online Meeting URL: None

SSIS and Powershell


UTC : Tue, May 27 2014 22:00 - 00:00
Event Time : Tue, May 27 2014 18:00 - 20:00 (GMT-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, May 27 2014 22:00 - 00:00


4821 Koger Blvd
Greensboro, North Carolina

Direction: None

Featured Presentation

SSIS and Powershell

Speaker: Shannon Lowder 52projects, inc

Summary: We’ve all built ETL frameworks, and we’ve all learned things along the way that make them better. So we have to go back and open all of those packages and update them so we keep them all following our standard. That takes time, time we don’t have to spend. Recently I’ve discovered SQLPSX, a set of modules for PowerShell that make it much easier to manage your frameworks. From auditing your packages to get a list of all the variables used in all of your packages, to adding connection strings and executables, all this and more is now possible via PowerShell. I’ll introduce you to the modules, as well as some of the problems I’ve hit along the way. I even have something for those of you looking for a unit testing framework for SSIS.

About Shannon: Shannon Lowder is a database architect and consultant with 14 years of experience in Microsoft SQL Server administration, performance tuning, and development. He specializes in designing highly available platforms and scalable data warehousing solutions including cloud-based solutions such as MIcrosoft Azure. In addition, he is well versed in mentoring both DBAs and developers with respect to Microsoft technologies with regards to the day-to-day operational demands of small a