News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM forum Bulk importing SalesOr...

Microsoft Dynamics CRM forum

Unanswered

Bulk importing SalesOrders via SSIS - contactid not populating?

(0) Share

Report

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

Categories:

All responses Img

All responses (1)

Answers Img

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2

Martin Dráb 228,651 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans