Eliminating Empty Output Files in SSIS

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...

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...

Creating Dynamic Outputs in SSIS

In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.

It's The Job

Today we have a guest editorial from Tim Mitchell that looks at the stereotypical geek. Have you worked with one? Is it harder to manage technical people? Or is it the job? Read Tim's thoughts and let us know if you agree.

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...

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...

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...

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. ...