CODEWITHSUNDEEP
ssisssis-2012ssis-2008
Gowtham Ramamoorthy
Gowtham Ramamoorthy

Reputation: 896

Dynamically Assign Column Delimiter to Flat file source in SSIS

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.

Upvotes: 1

Views: 857

Answers (1)

Gowtham Ramamoorthy
Gowtham Ramamoorthy

Reputation: 896

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.

enter image description here

Upvotes: 1

Related Questions