Hiya All

I'm trying to transfer the device table from SC to a SQL Server db and I'm getting errors around reconciliation.
Connect-it keeps trying to add the record to SQL Server instead of updating it therefore it errors as I've set a primary key in SQL, I think the problem is around reconciliation any ideas???
 
I've already set reconciliation to update or insert but the Connect-It scenario only trys to add the record not update it. I think I'm probably missing something any ideas?

Also do any of you know what this error message means?...

Line 1:syntax error '=';'=' should be Select_field

This occurs when I try and set logical.name as a reconciliation key!

Cheers

Chris