-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over thirteen years of data management experience. He is the founder and principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at @Tim_Mitchell.

Archives: April 2015

Dear Vendor: Keep My Information Secure

Dear vendor:

Dear Vendor: Keep My Information Secure

If you’re reading this, we have done business together, either directly or indirectly. You might be a retail website from which I purchase products or services. You could be a social media empire on which I share blog posts, life events, and… Read more

2 comments, 5,515 reads

Posted in Tim Mitchell on 27 April 2015

The SSIS Object Variable and Multiple Result Sets

In my most recent post in this series, I talked about how to use the SSIS object variable as an ADO recordset as a source in a data flow. By loading the result set of a query into this variable, the contents of the variable can be read by an… Read more

6 comments, 1,803 reads

Posted in Tim Mitchell on 27 April 2015

Somebody Doesn’t Like You, and That’s Good

Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself that must be fixed. It feels like a failure that you’ve let someone down, or even worse, it can make you feel like you’re somehow broken or deficient.

I would… Read more

10 comments, 425 reads

Posted in Tim Mitchell on 24 April 2015

Using the SSIS Object Variable as a Data Flow Source

Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In my last post on this topic, I demonstrated how an SSIS object variable containing a .NET DataSet object could be used by the for each loop container as an… Read more

10 comments, 7,094 reads

Posted in Tim Mitchell on 20 April 2015

Handling Mixed Format Data Files in SSIS

Some time back I wrote about how to use the script component to parse out ragged data files in SSIS. In this post, I’ll continue the discussion to describe how to handle mixed format data files – specifically, those with several different record types in each file.

In a… Read more

3 comments, 5,590 reads

Posted in Tim Mitchell on 13 April 2015

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

When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there is a museum located in a home in which he once lived. I’ve been a Poe fan since high school, and am looking forward to seeing some of the… Read more

0 comments, 460 reads

Posted in Tim Mitchell on 10 April 2015

On Failure: On Being a Screw-Up

“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 described above. I didn’t want to be known as someone whose ideas didn’t work. And to that end, I was successful: most of what I tried was successful. The… Read more

7 comments, 5,538 reads

Posted in Tim Mitchell on 9 April 2015

Null, empty string, or zero?

The answer: It Depends.

One of the more common problems I encounter when managing data quality, especially in an ETL process, is the handling of null values, blanks, and zeroes. When I put on my preaching shoes to talk about bad data, this is one the areas I have to… Read more

5 comments, 7,273 reads

Posted in Tim Mitchell on 6 April 2015

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

This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s PASS Summit in Seattle. I was pleasantly surprised to learn that my session, “Building Bullet-Resistant SSIS Packages”, was among these. All of these sessions (including lots of other content)… Read more

1 comments, 5,778 reads

Posted in Tim Mitchell on 4 April 2015

Finally, a Universal Data Integration Utility

Earlier today, the fine folks at the F. Oobar Corporation released a revolutionary product: a universal data integration utility. This software component, known as the Baseline Ongoing Generic Utility for Synergy, will run on any platform and can convert data to and from almost any format automatically. It also reads… Read more

6 comments, 480 reads

Posted in Tim Mitchell on 1 April 2015