Bulk importing SalesOrders via SSIS - contactid not populating?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Using SSIS / KingswaySoft to push salesorder records from a SQL Server table into Dynamics 365 CE

Said SQL Server source table has contactid , that does have corresponding record in Dynamics 365 Contact table

KingswaySoft happily maps all other source columns to target table - except contactid -

Column just will not appear in the column mapping dialogue. Contactid column definitely exists on the target table

Any ideas how to force this column to column mapping, please?

Additional :
SalesOrder record inserts successfully without contactid
Attempted a follow up update / upsert process using ordernumber as key - still contactid makes a no show on the column to column mapping

All responses (1)

Answers (0)

Daniel Cai 935 on at

Like (0)

Report

RE: Bulk importing SalesOrders via SSIS - contactid not populating?

Salesorder entity uses a multi-target lookup field to create relationship, there is no contactid field. In order for your write to work, you would need to map your source contactid field to the customerid field, and then specify the input value for customeridtype field to be "contact", then you should write properly.