Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, and trainer. He has been building data solutions for over 20 years, and is a 13-time recipient of the Microsoft Data Platform MVP award (2010-2022). He is the founder and principal data architect at 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 the author of the book The SSIS Catalog: Install, Manage, Secure, and Monitor your Enterprise ETL Infrastructure, coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives Vol 2.

You can visit his website and blog at TimMitchell.net or follow him on Bluesky at https://bsky.app/profile/tmitch.net.

Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt

Website: https://www.TimMitchell.net
Bluesky: tmitch.net

All authors

Processing Multiple Files in SSIS with the Foreach Loop

by Tim Mitchell

Tim Mitchell

Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly...

2018-12-17

184 reads

Processing Multiple Files in SSIS with the Foreach Loop

by Tim Mitchell

Tim Mitchell

Yesterday I wrote about the little-known but still useful multiple flat file connection manager. In this post, I will briefly show a more commonly used alternative approach for processing...

2018-12-17

20 reads

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

by Tim Mitchell

Tim Mitchell

When extracting data from a flat file, it is handy to have the name of the file from which the...

2018-12-15

439 reads

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

by Tim Mitchell

Tim Mitchell

When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for...

2018-12-15

9 reads

Using the SSIS Multiple Flat Files Connection Manager

by Tim Mitchell

Tim Mitchell

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data...

2018-12-15

326 reads

Using the SSIS Multiple Flat Files Connection Manager

by Tim Mitchell

Tim Mitchell

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are...

2018-12-15

6 reads