Developer forum

Forum » Development » Data Integration: repeated table and column names

Data Integration: repeated table and column names

E-mail notifications
Hafsteinn Hjartarson
Hafsteinn Hjartarson
Reply
Posted on 10/01/2019 10:46:40

When setting up a Dynamicweb provider data integration job I noticed that the drop down list in "Source Table" contains multiple instances for the same table (see attachement di.png)

when selecting any of the AIContactDetails (a table that contains 4 columns) values the Data Column Mapping shows 4 source columns but all drop down values have the same value; ContactID (see attachment ci.png)

The attachmend db.png shows the table that I want to use as a source table (dbo.AIContactDetails)

 

Any help with this is greatly appreciated.

ci.png db.PNG di.png

Replies

 
Nicolai Pedersen
Posted on 10/01/2019 14:31:04
Reply

Hi Hafsteinn

I can see you have the table multiple times in the database on different owners. Apparently we never had that situation before and does not support it. Maybe you are able to change the connection string on the SQL provider to use a user that will only give you access to one set of the tables...? Or if possible create a custom table on your SQL with a unique name and copy data to that one from the one you have the data in...

Sorry about the inconvenience, Nicolai

 
Hafsteinn Hjartarson
Hafsteinn Hjartarson
Posted on 11/01/2019 15:21:12
Reply

Thank you Nicolai, this was indeed the problem.

 

You must be logged in to post in the forum