Introduction The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language. The examples are built in SSIS 2005. Why? Not everyone has access to SSIS …
Continue reading An Introduction to the SSIS Expression Language
Author:Andy Leonard
An Introduction to the SSIS Expression Language
Introduction The SSIS Expression Language is one of the steeper slopes on the SSIS learning curve. Many database professionals have never been exposed to the syntax. In this series, I provide examples that demonstrate common uses for the SSIS Expression Language. The examples are built in SSIS 2005. Why? Not everyone has access to SSIS …
Continue reading An Introduction to the SSIS Expression Language
Presenting at New England SQL Server User Group!
I am getting psyched about presenting to the New England SQL Server User Group in a couple weeks! On 12 Feb I’ll be talking about Incremental Loads, Change Data Capture, and SSIS 2008. The bonus is I get to hang out with my friend Adam Machanic! If you read this blog and will be in the …
Continue reading Presenting at New England SQL Server User Group!
Presenting SSIS Scripting Tonight!
I am honored to join Jessica Moss to co-present SSIS Scripting to the Hampton Roads SQL Server User Group Thursday 18 Dec 2008! This is a reprise of our PASS Summit 2008 presentation by the same name. Much of the code for this presentation is located at the SSISTwitterSuite project on CodePlex – the cool stuff is out …
Continue reading Presenting SSIS Scripting Tonight!
Toughest Career Challenge
I’ve been tagged at least twice now (Denis Gobo and K. Brian Kelley) for the Toughest Career Challenge. My story: I took a job as a contractor, temp-to-perm. It was a relatively small shop and I was the only person working with databases. Since the shop was small I wore other hats. One of them …
Continue reading Toughest Career Challenge
Co-presenting to Richmond SQL Server Users Group Thursday!
I am honored to join Jessica Moss to co-present SSIS Scripting to the Richmond SQL Server Users Group Thursday 11 Dec 2008! This is a reprise of our PASS Summit 2008 presentation by the same name. Much of the code for this presentation is located at the SSISTwitterSuite project on CodePlex – the cool stuff is …
Continue reading Co-presenting to Richmond SQL Server Users Group Thursday!
SQLPass 2008: Thursday Keynote
Introduction So, it’s a few minutes before the PASS Summit 2008 Thursday keynote, and I’m settled into the Press Table behind the sound board. Tony Davis is here. Steve Jones is here. And I’m seated beside Brent Ozar. Rushabh Mehta To complement Wayne Snyder’s entrance on a bike yesterday, Rushabh Mehta showed up this morning …
Continue reading SQLPass 2008: Thursday Keynote
SQLPass 2008: The PASS Summit – Day Two
Introduction “Hey Andy? What happened to your Day One post?” Excellent question. I was going to post a Day One post – really I was – but I got side-tracked. I won’t mention any names, but I will blame the major offenders by their Twitter handles: @BrentO, @sqlagentman, and @SqlBatman. These gentlemen forced me – through …
Continue reading SQLPass 2008: The PASS Summit – Day Two
Speaking at Raleigh Code Camp tomorrow!
Code Camp RDU Fall 2008 is tomorrow (15 Nov 2008)! If you’re going to be in the Raleigh area tomorrow and are interested in anything related to Microsoft technology, register and check out the sessions. I always have a blast in Raleigh! I will be presenting my popular session: Incremental Loads, Change Data Capture, and SSIS …
Continue reading Speaking at Raleigh Code Camp tomorrow!
PASS Summit 2008: SSIS Scripting
It’s That Time of Year Again… I am honored to again be presenting at the PASS Summit! I’m even more honored to be co-presenting SSIS Scripting with Jessica Moss, SQL Server MVP! Errata Somewhere in the abstract for this presentation I listed the following three goals: Explore SSIS Script Objects Best practices for script coding …
Continue reading PASS Summit 2008: SSIS Scripting
