Next Meeting: Mon, Jul 13 2015
July 2015 meeting
Event Type: In-Person
Online Meeting URL: None
Monthly meeting, July 13, 2015.
UTC : Mon, Jul 13 2015 21:30 - 23:30
Event Time : Mon, Jul 13 2015 17:30 - 19:30 Eastern Daylight Time
Your Local Time: Mon, Jul 13 2015 21:30 - 23:30
15 Cornell Rd
Albany, New York
Unleashing SSIS with expressions, configurable properties, and parameters
Daniel Bowlin, Data Integration Developer Time Warner Cable
Have you struggled to build SSIS packages? You are starting to get the hang of it, but many things more than basic data movement remain a frustrating challenge. The SSIS expression language is an incredible source of power within SSIS but a profound challenge to many. Another area of power and flexibility in SSIS is its very broadly scoped configurability. This presentation will walk through the basics of the SSIS expression language including the whys and wherefores of a few expression peculiarities. Then we will review how you can use those expressions to configure so many of the properties in SSIS that you might barely recognize what your package can do when you are finished. Finally we will review input parameters and how to further influence the behavior of your packages at run time. Download includes slide deck, expression samples, and some packages.
I am a data integration developer at Time Warner Cable. I have been working with SQL Server technologies since the late 90s. About 6 years ago I specialized in the SQL Server BI stack. Lately I have been almost exclusively working in SSIS.