Skip to content
+1-888-319-3663

HELP ARTICLE

SQL Table destination in SmartConnect will not update existing records


Running a SmartConnect map and using the SQL table destination.  The import is set to “Update Existing” however it is not updating the existing records, it keeps inserting new records.  

In order to update existing records when using the SQL table destination, the following 4 conditions need to be met.  

1.  The SQL table must have a key field configured in the table. If there is not a key field defined in the destination table, then updates are not possible and maps will always insert a new row.

2.  The key field in the SQL table CANNOT be an identity column (a column that automatically populates like DEX_ROW_ID does in GP)

3.  You MUST map a source field to the key field in the SQL table. You can’t use a rolling column, or a script or a constant, you have to map a field FROM the source file to the key field in the SQL table.

4.  When you configure the data source, you select the source field you have mapped as the “Key Field” in the data source.

If all 4 conditions are met, then the map will automatically do inserts and updates (if “Update Existing” is marked) based on the key fields. If the above 4 conditions are not met, then any imports will always append a new record to the table instead of updating an existing record.

RECENT POSTS


Creating an Integration in SmartConnect.com
eConnect error - Login failed for user
32 bit Excel Add-in for SmartConnect 21 does not appear after installing.
Connection could not be validated when using Excel data source
Salesforce Error: Unable to create/update fields check security settings

POPULAR POSTS


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.