Skip to content
+1-888-319-3663

COMMUNITY FORUM

Map to SQL Table

Patty asked 6 years ago
Simple SQL table.  Getting error processing “Tenant SQL Server XXXXX Database : XXXX  the column name ‘Store_ID’ is specified more than once in the SET clause or column list of an INSERT.  A column cannot be assigned more than one value in the same clause.  Modify the clause to make sure that a column is updated only once.   
 
It repeats this statement for all fields in the table. 
Answers
Patrick Roth Staff answered 6 years ago
Patty,
This is a bug in SC 2014.
There are two ways to resolve this.
1 update to SC 2015 as it is fixed in that version
if you must stay on SC 2014 then you have to make sure that your Key Fields are selected so that each row of data is unique. Meaning that if you have 10 rows of source data then SC shows 10 documents.
patrick

If you would like to submit an answer or comment, please sign in to the eOne portal.