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

193 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

27 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

334 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

28 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

447 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

29 reads