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 realized I am tired of looking back through my presentations to build them.  Here is a sample script that you can… Read more

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 query
2. Learn a new language (Ruby)

The problem was simple.  I needed to easily identify the problem areas of a complex stored procedure.… Read more

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 which is usually defined as char(13) and converting it into a bigint.  All valid ISBN13s are valid bigint.… Read more