SQL Server Innovators Guild

Welcome to the Greenville, SC Chapter

Welcome

We have meetings on the first Tuesday of most months.  Our group meets at the Greeville Campus of ECPI. Our normal room is room #236 but check the visual displays when you arrive to confirm.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session.  Unless noted in the meeting notes the schedule for each meeting will be:

6:00 - 6:30 - Food and a chance to meet other SQL Server users. Sponsored by FGP

6:30 - 6:45 -
General Q&A session & Announcements

6:45 - 8:15 - Presentation(s)

8:15 - 8:30 - Question & Answer session

Upcoming Events

Next Meeting: Tue, Aug 04 2015

Closing the SSIS Package Management Story with BIPS

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://ssig201508.eventbrite.com

6:00 – 6:30 Pizza and Networking sponsored by FGP
6:30 – 6:40 Announcements
6:40 – 7:00 TBD
7:00 – 8:15 Jim Christopher: Closing the SSIS Package Management Story with BIPS
8:15 – 8:30 Closing remarks

Closing the SSIS Package Management Story with BIPS
Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages.

BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages.

In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a Microsoft MVP for PowerShell (2011-2016). Jim is a frequent speaker at technical user groups and conferences. He is currently Curriculum Director at Pluralsight.

When

iCal
UTC : Tue, Aug 04 2015 22:00 - 00:30
Event Time : Tue, Aug 04 2015 18:00 - 20:30 Eastern Daylight Time
Your Local Time: Tue, Aug 04 2015 22:00 - 00:30

Where

1001 Keys Dr
Greensville, South Carolina

Direction: None

Featured Presentation

Closing the SSIS Package Management Story with BIPS

Speaker: Jim Christopher, Owner Code Owls LLC

Summary: Existing SSIS automation solutions are focused on forward-motion activities: creating packages and pushing them to the server. Little or no thought is given to the management of the packages once they are in production - existing tooling offers nothing to help you understand and manage a live, money-printing ETL workflow based on SSIS packages. BIPS is an open source project that allows you to manage a live SSIS package tree from PowerShell. It closes the automation loop, providing the ability to learn and discover the features of an existing package deployment tree as well as manipulate it. In short, the goal of BIPS brings a devops perspective to managing your SSIS packages. In this session, you will learn how to leverage BIPS in your own environment. Specific attention will be given to searching and filtering tasks and data flows on arbitrary criteria and manipulating specific parts of the ETL workflow from the shell.

About Jim: Jim gained 18 years of professional experience developing complex software projects in highly regulated industries, including education, gaming, and defense. His professional drive is designing software, systems, and user experiences for automation, a theme that has earned him a Microsoft MVP for PowerShell (2011-2016). Jim is a frequent speaker at technical user groups and conferences. He is currently Curriculum Director at Pluralsight.

Attachments

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

Red gate 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids