That’s right my friends we are meeting on Valentines day.  I hope to see a good turn out for this meeting despite the ominousness of the day

 

If you don’t make it to the meeting you will miss one of the primary benefits of being involved in PASS; networking with your peers.

 

I hope to see you on Tuesday.

* Networking with your peers: Networking is the answer.

* WiSSUG Business: Need volunteers

*Presentation by Dexter Jones: SQL Server Integration Services Expressions

 

 

Presentation Preview

SSIS Expressions

SQL Server Integration Services (SSIS) is a like a toolbox chock full of interesting and powerful tools for ETL as well as many other tasks. But there's a less obvious tool that can make our SSIS packages more capable and less complex at the same time. Sound interesting?

 

That “tool” is Property Expressions, commonly referred to simply as Expressions. By using Expressions, it becomes possible to dynamically update SSIS component properties at runtime, which opens a whole range of possibilities within SSIS.  In this presentation, we see just how (and how easy it is) to make use of Expressions to add power and flexibility to an SSIS package.

Warning: If you dig lengthy PowerPoint slides, this session might not be for you; we will spend most of the presentation using Expressions in SSIS to build a package to perform actual work.

 

Dexter Jones is a Senior DBA with Foley & Lardner in Milwaukee.

A recovering software developer, he has been working with SQL Server since 1996.

When not tinkering with SQL Server, he enjoys designing and building loudspeakers.