Tim_Mitchell.jpg

Tim Mitchell

Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer.  He has been working with SQL Server for over 10 years, working primarily in business intelligence, ETL/SSIS, database development, and reporting.  He has earned a number of industry certifications and holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is a Microsoft SQL Server MVP.  Tim is an independent business intelligence consultant and a group principal with Linchpin People.

As an active member of the community, Tim has spoken at national, regional, and local venues including the SQL PASS summit, SQL Connections, numerous SQL Saturday events, and various user groups and PASS virtual chapters.  He is active in the North Texas SQL Server User Group in Dallas, and is a volunteer for PASS.  Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com.

Tim is a contributing author on the charity book project MVP Deep Dives 2, and is coauthor of SSIS Design Patterns.

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

http://www.timmitchell.net http://feeds.feedburner.com/TimMitchell

In this session, we'll review methods for cleaning up dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native components, T-SQL, SSIS scripting, and DQS.

Blog posts RSS

Above All, Good Judgment 24 Aug 2015
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 ...

We Don’t Trust This Data 14 Aug 2015
“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 ...

Downloading SFTP Files with SSIS 03 Aug 2015
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 limited in its ...

Synchronous Processing in the SSIS Script Component 29 Jul 2015
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 ...

New Course: Building Better SSIS Packages–Denver and Boston 05 Jun 2015
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 ...