Dynamically Assign Column Delimiter to Flat file source in SSIS

Question

Goal - To import multiple flat files(may be 1000's or more every day) with different column delimiter

I was trying to dynamically assign the column delimiter to a flat file source connection manager in SSIS. (It seems that is not possible since there is no in-built function(Column Delimiter) in SSIS to dynamically assign values) Also I can't use "Bulk Insert Task" to load different flat files since I need to include a derived column in the data flow.

How can I achieve this in the data flow/data flow plus(cozyroc) task ? Any help is much appreciated.

Answer 1

This is doable via 3rd party SSIS component (DataFlow plus task) where we can define the column delimter as a variable. Please see below screen shot.