Tim Mitchell

A full day with me, SSIS, and Edgar Allan Poe

• by Tim Mitchell

• Tim Mitchell

When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...

2015-04-10

609 reads

On Failure: On Being a Screw-Up

• by Tim Mitchell

• Tim Mitchell

“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...

2015-04-17 (first published: 2015-04-09)

5,679 reads

Null, empty string, or zero?

• by Tim Mitchell

• Tim Mitchell

The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...

2015-04-15 (first published: 2015-04-06)

7,485 reads

Best of PASS Summit 2014: Building Bullet-Resistant SSIS Packages

• by Tim Mitchell

• Tim Mitchell

This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s...

2015-04-13 (first published: 2015-04-04)

5,938 reads

Finally, a Universal Data Integration Utility

• by Tim Mitchell

• Tim Mitchell

Earlier today, the fine folks at the F. Oobar Corporation released a revolutionary product: a universal data integration utility. This...

2015-04-01

727 reads

Why I Want to Have Coffee With You

• by Tim Mitchell

• Tim Mitchell

Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes...

2015-04-10 (first published: 2015-03-31)

7,878 reads

The Idea Book

• by Tim Mitchell

• Tim Mitchell

How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...

2015-03-25

768 reads

Fix Inconsistent Line Terminators in SSIS

• by Tim Mitchell

• Tim Mitchell

There is a flat file processing issue I’ve run into a number of times over the years, and it’s come...

2015-03-23

1,478 reads

Iterating Through Excel Worksheets with Biml

• by Tim Mitchell

• Tim Mitchell

Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...

2015-03-25 (first published: 2015-03-16)

7,652 reads

On Failure: Getting Up

• by Tim Mitchell

• Tim Mitchell

In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...

2015-02-16 (first published: 2015-02-06)

5,941 reads