SSIS Expression Language and the Derived Column Transformation

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and the Derived Column Transformation. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). …
Continue reading SSIS Expression Language and the Derived Column Transformation

SSIS Expression Language and Variables

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). Build The Demo Project …
Continue reading SSIS Expression Language and Variables

SSIS Expression Language and Variables

Introduction This post is part of a series titled An Introduction to the SSIS Expression Language. In this post, I demonstrate the SSIS Expression Language and Variables. To build the demo project described in this article you will need SSIS 2005 and the AdventureWorks sample database (which can be downloaded at http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004). Build The Demo Project …
Continue reading SSIS Expression Language and Variables

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

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!

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