Enhanced Threading Framework V3 for SSIS

• by Josef Richberg

• SQLRunner

I decided to revisit my framework to see if I could improve the performance and possibly increase the number of scenarios this framework could be used in.  Turns out...

2016-03-24

2 reads

Validating in-line DataFlow records with a Stored Procedure

• by Josef Richberg

• SQLRunner

I have text file that contains data for a given fiscal period.  In this particular file there are around 2...

2013-11-14 (first published: 2013-11-05)

2,086 reads

Validating in-line DataFlow records with a Stored Procedure

• by Josef Richberg

• SQLRunner

I have text file that contains data for a given fiscal period.  In this
particular file there are around 2 million records.  The file needs to be
split into...

2013-11-05

PASS Summit 2013 - Examples Package

• by Josef Richberg

• SQLRunner

I was asked by some attendees of my PASS 2013 Session, Unseen Minions : Improving parallel processing in SSIS, if I had any...

2013-10-22

436 reads

SSWUG Summer Camp

• by Josef Richberg

• SQLRunner

I'm speaking at SSWUG Summer Camp!  Thankfully, I can be at home, in my pool AND be at summer camp...

2013-06-26

903 reads

Speaking at PASS Summit 2013!

• by Josef Richberg

• SQLRunner

I am honored to say that have been selected to present this year.  I'll be giving a talk on my...

2013-05-22

368 reads

Converting Inches to Centimeters - Long Hand

• by Josef Richberg

• SQLRunner

Today I had to write a little function that takes the long had version of a fraction, say 8 3/4...

2013-02-26

1,170 reads

Converting Inches to Centimeters - Long Hand

• by Josef Richberg

• SQLRunner

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

2013-02-26

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

• by Josef Richberg

• SQLRunner

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

2012-12-12

713 reads

Existence Check Deconstructed -- SSIS Lookup Transformation

• by Josef Richberg

• SQLRunner

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

2012-11-10

1,020 reads