Repeated Column Names issue
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
August 31st, 2012 1:11pm

Stepejen, just rename the file column yourself to what you desire in the Flat File Manager (advanced). Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2012 1:49pm

Hi, Just Rename one of the same name columns in the connection manager and map the renamed column in the required destination. Cheers...!!
August 31st, 2012 10:46pm

Hi, Many thanks for the info, i will give it a go! Regards
Free Windows Admin Tool Kit Click here and download it now
September 1st, 2012 7:55pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics