SSIS Script Component Source -- Proc/Select Stmt

I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations.  I had to build one moments ago and...

SSIS Script Component Source -- Proc/Select Stmt

I've been asked on several occassions to provide an example of the custom sources I use in my "SSIS Tips&Tricks" presentations.  I had to build one moments ago and...

PASS Virtual Chapter: SSIS Enhanced Threading Framework

I'll be giving a presentation tomorrow, Tuesday 2/21/2012 at 12PM EST on my Enhanced Threading Framework design.  Here is the...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 
Quickly identify what tables have the highest...

Spruced up query_io_reader.rb

 I built a small ruby program a while back to help with two things:

1. Quickly identify what tables have the highest IO in a particular
...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 

Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)

 
The...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a common situation; invalid conversions...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column.  The conversion
was taking an ISBN13...

Using the Error Output of the Derived Column

The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column.  The conversion was taking an...

An Interview at SSWUG

I've been a bit busy for the last few weeks, with the holidays, PASS, working on SSIS (more to come),...