Skip to content
+1-888-319-3663

COMMUNITY FORUM

Changes Only – Data Source Type

Alberto asked 6 years ago
I am trying to perform a Map with Changes Only Data Source but when I select a Table from my Database I receive an error like this: “You cannot create a change data source on a table without a key”…
 
Do you have any idea about it?
 
Thanks!
 
 
Answers
Chris Hanson Staff answered 6 years ago
Alberto, our SQL Change Data Source maps require at least one key field setup on the table. SQL allows you to create a table without a primary key – but we can’t track changes on that table as we use the Key Field(s) on a table to do so.
 
You need to add a key field to that table and then it would work.
 
Thanks
H
Alberto replied 6 years ago

Thanks a lot Chris!

I checked out the table and it doesn’t had a key field. Then, I added a primary key to the SQL table and it works fine!


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