Data Source - Message "Table contains duplicate column names"

[mangesh9]

Hi,

I have created one Data source record of type File, with Retrieval method - FTP, provided connection details as path, server and credentials but when I hit test, getting message as "Table contains duplicate column names". Any suggestion?

[Gangadhar Ravi]

Please check if your destination table is having any Duplicated lable names for columns.

PS: Hit like, Helpful or Correct depending on the impact of the response

Thanks,

Sai.

[Dwight S_1]

I ran into the same thing but I found that it wasn't on the destination table, but the duplicate was in the import CSV and what it was preventing was the creation of a duplicate column which is a good thing because a duplicate column in the dictionary/database would be a problem.

To resolve the problem, I just deleted the duplicate column from the CSV and the problem went away.