Friday, August 31, 2012 5:02 PM
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.
Friday, August 31, 2012 5:40 PMModerator
just rename the file column yourself to what you desire in the Flat File Manager (advanced).
Arthur My Blog
- Proposed As Answer by Todd McDermidMVP, Moderator Friday, August 31, 2012 11:09 PM
Saturday, September 01, 2012 2:37 AM
Just Rename one of the same name columns in the connection manager and map the renamed column in the required destination.
Saturday, September 01, 2012 11:53 PM
Many thanks for the info, i will give it a go!