The Column Name ‘MyColumn’ is specified more than once in the SET Clause.

Published: Jul 08, 2014
Post Author Written by eOne Solutions

I have my SmartConnect destination set as a Microsoft SQL Table and am receiving the error about the column name being specified more than once in the SET clause.

Click on the Group Data option on the SmartConnect Mapping window and set the Group On checkbox for each source column that is set as the Key Fields from the Data Source

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.