Space Sensitivity in SSIS Lookups

It's been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup...

[Off Topic] Workstation Upgrade

It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest...

More Free Training Resources

A recent blog by Jack Corbett (No Training Budget Still No Excuse, followed up by SSC’s Steve Jones here) hit...

The Netbook: Upgrade to Windows 7

I’m more than 2 months into the netbook experience, and I’m happy to report that it’s still a good investment. ...

Upcoming Speaking Engagements for Q4

In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence.  For October, I...

Skipping Items in a Foreach Loop

Recently, my friend Jack Corbett asked a question on Twitter:

In a nutshell, the SSIS foreach loop will enumerate a given...

North Texas SQL Server User Group Meeting on Thursday

The monthly North Texas SQL Server User Group (NTSSUG) meeting will be held this Thursday, September 17, at 7:00pm at...

Getting Into the Biz, Part 3

In a couple of previous posts (Part One and Part Two), I shared some thoughts about starting a career path...

SQL Saturday Dallas Update

Just a quick update on the SQL Saturday event we are planning for the Dallas area next year.  Late last...

Updating Existing Data with SSIS

I see a lot of questions on the forums about updating existing data in SSIS.  When the update is dynamic...