Subscribe to this blog
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: March 2015
Why I Want to Have Coffee With You
Yesterday I read an article entitled “Why I Don’t Want to Have Coffee With You”, in which the author writes that he doesn’t have the time or the desire to simply “have coffee”. While I empathize with some of the author’s justifications for his position, I was disappointed… Read more
10 comments, 7,810 reads
Posted in Tim Mitchell on 31 March 2015
The Idea Book
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be easy to add automation to [y]”, or “It would be a lot of fun to work on a project to build [z]”? For me, this has happened a lot, and… Read more
1 comments, 747 reads
Posted in Tim Mitchell on 25 March 2015
Fix Inconsistent Line Terminators in SSIS
There is a flat file processing issue I’ve run into a number of times over the years, and it’s come up again several times recently. The issue relates to the line terminators used in data files. Occasionally, changes to the systems generating these data files, or perhaps even manual edits,… Read more
10 comments, 1,235 reads
Posted in Tim Mitchell on 23 March 2015
Iterating Through Excel Worksheets with Biml
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in this post by Koen Verbeeck) to addressing multiple worksheets in a single document, configuring SSIS to properly read from or write to Excel documents is tedious at best. While there… Read more
10 comments, 7,595 reads
Posted in Tim Mitchell on 16 March 2015