Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of data management experience. He is a partner with Linchpin People and is the 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 twitter.com/Tim_Mitchell.

Above All, Good Judgment

What is permissible is not always honorable. – Marcus Tullius Cicero

Rules. Best practices. Guidelines. Design patterns. Policies. All are good and necessary, and you’ll rarely find anyone who will argue against the need to establish boundaries and set expectations. But can adherence to rules and design patterns be taken… Read more

0 comments, 94 reads

Posted in Tim Mitchell on 24 August 2015

We Don’t Trust This Data

“Learning to trust is one of life’s most difficult tasks.” –  Isaac Watts

As data professionals, there are times when our jobs are relatively easy. Back up the databases. Create the dashboard report. Move the data from flat files to the database. Create documentation. There are lots of cogs… Read more

6 comments, 2,102 reads

Posted in Tim Mitchell on 14 August 2015

Downloading SFTP Files with SSIS

If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to download a file stored on an SFTP (secure FTP) server, but SSIS does not natively support this operation. There is a built-in FTP task in SSIS, but it is very… Read more

1 comments, 466 reads

Posted in Tim Mitchell on 3 August 2015

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over the flow of data, leverages the full power of the .NET Framework namespaces, and can be used as a source, destination, or transformation in data… Read more

0 comments, 1,458 reads

Posted in Tim Mitchell on 29 July 2015

New Course: Building Better SSIS Packages–Denver and Boston

Earlier this week, I confirmed two full-day seminars I’ll be delivering in conjunction with SQL Saturday events this fall. I’ve got a brand new course entitled “Building Better SSIS Packages” which I’ll be delivering in Denver and Boston. Here’s a brief into to this course:

SQL Server Integration Services… Read more

0 comments, 222 reads

Posted in Tim Mitchell on 5 June 2015

The Key to Successful Analysis

The key to successful analysis is to ask enough good questions.

How do you know that you’ve asked enough questions? When you think you have all the information you need to get started, ask 10 more good questions. Those ten questions will lead to five more, which will lead to… Read more

0 comments, 1,657 reads

Posted in Tim Mitchell on 3 June 2015

A Tool for Every Job

I’m a fixer. A tinkerer. As a kid, I would take my toys apart just to see how they worked, and to prove that I could put them back together again (and these experiments often had mixed results). Even today, I’m still kind of a shade tree handyman. In fact,… Read more

4 comments, 455 reads

Posted in Tim Mitchell on 1 June 2015

Row Numbers and Running Totals in SSIS

During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL process itself, as well as for use in the destination database. Having an arbitrary, incrementing row number assigned to each row can help to determine the order in which the… Read more

0 comments, 522 reads

Posted in Tim Mitchell on 26 May 2015

Advanced SSIS Training Classes This Fall

Now that the details have been finalized, I can announce that two new SSIS classes are coming up this fall. My Linchpin People cohort Andy Leonard and I will be delivering our Advanced SSIS training class in two new locations later this year: in the Atlanta area in September, and… Read more

0 comments, 183 reads

Posted in Tim Mitchell on 21 May 2015

Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (af8cc091-a628-437f-8918-348486ad1d80 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

The post Temporary Post Used For Theme Detection (d2df4373-a605-4b61-86ee-a1afe06d7e22 – 3bfe001a-32de-4114-a6b4-4005b770f6d7) appeared first on Tim Mitchell.

Read more

0 comments, 162 reads

Posted in Tim Mitchell on 20 May 2015

How To Get Fired from an ETL Developer Job

Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a lot of ETL code. Some of that code was really good, well-thought-out and carefully executed. Other load processes were – well, let’s just say that they provide plenty of consulting… Read more

6 comments, 1,327 reads

Posted in Tim Mitchell on 15 May 2015

Office Hours Webinar: Is Biml Right for You?

If you’ve read my blog or attended one of my presentations before, you almost certainly know that I’m a huge fan of Biml. If you’re building or maintaining SSIS packages (or you’re supervising those that do), you owe it to yourself to learn about Biml. I don’t make a lot… Read more

0 comments, 3,889 reads

Posted in Tim Mitchell on 12 May 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,149 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

1 comments, 529 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, 148 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, 5,561 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

1 comments, 5,131 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, 176 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,248 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, 6,806 reads

Posted in Tim Mitchell on 6 April 2015

Older posts