Not Able to work with ODBC connection in Visual Studio 2017

  • Thread starter Thread starter SHAHAB HAIDAR
  • Start date Start date
S

SHAHAB HAIDAR

Guest
Hi All,


I am not able to connect with MySQL ODBC destination in my visual studio 2017 15.9.13.

The Error message is :



Exception from HRESULT: 0xC0207015

Error at Data Flow Task [ODBC Destination[40]]: There is more than one data
source column with the name "Encounter Number". The data source column names must be
unique.

(Microsoft Visual Studio)




This error is occurring in only Visual studio 2017. Visual studio 2013 & 2015 is installed on the same machine and i am successfully able to connect to MySQL through the same connection string with visual studio 2013 & 2015.

It keeps saying column name should be unique though column name is unique in each table (source and destination).

Continue reading...
 
Back
Top