Duplicate header names with unique values in fields outputting duplicate values?

Using and Delimited File Source objects.  The data set in question contains duplicate header names, but the fields contain distinct values.  For example, given two column header names of "INSERT_DATE", first instance for a record will have a date value of 09/29/2014, while the second has a value of 08/26/2018. 

Even though Centerprise correctly applies a numeric marker to the second instance, the output for both is identical.  In this case, both INSERT_DATE & INSERT_DATE_2 will output 09/29/2014.

I can work around this by manually modifying the source data, but it seems I shouldn't have to do this, as the dataflow editor differentiates the two duplicate header names.


Please sign in to leave a comment.