Repeated Column Names issue

Question

Hi,

  Would you mind provide some thoughts of the following issues? thanks.

  I am trying to read in more than 100 csv files by using SSIS foreach loop containter. Each CSV file follows the same format and same column name, type. However there exist repeated column names in each csv file, therefore I kept getting the warning 'There is more than one data source column with the name ...', and then fail.

  I can't modify the source data as it's Read Only, moreover i will need to build this up and runs daily as there are csv files keep coming in everyday.

  Any ideas/comments will be very helpful. Many thanks.

Regards
Stephen

Answer 1

Stepejen,

just rename the file column yourself to what you desire in the Flat File Manager (advanced).

---

Arthur My Blog

Answer 2

Hi,

Just Rename one of the same name columns in the connection manager and map the renamed column in the required destination.

Cheers...!!

Answer 3

Hi,

   Many thanks for the info, i will give it a go!

Regards