Converting Inches to Centimeters - Long Hand

Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...

Converting Inches to Centimeters - Long Hand

Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...

Working with Excel Destinations in SSIS - 0xC0202025, 0x80040E21

Working with Excel in SSIS is not fun and something I whole-heartedly discourage.  With that said, I had a not...

Existence Check Deconstructed -- SSIS Lookup Transformation

There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query....

Existence Check Deconstructed -- SSIS Lookup Transformation

 There are countless ways to mix and match components in SSIS to simulate
what SQL Server does in a query.  Here I am going to show you how to...

Existence Check Deconstructed -- SSIS Lookup Transformation

There are countless ways to mix and match components in SSIS to simulate what SQL Server does in a query.  Here I am going to show you how to...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...

SSIS Data Flow Tuning

 During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.

When a source is pulling in data, it places them into...

SSIS Data Flow Tuning

During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...

SSWUG Expo..I'm up!

I am proud to say that one of the webcasts I taped last year for SSWUG is part of the...