web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Bulk importing SalesOr...

Customer experience | Sales, Customer Insights,...

Unanswered

Bulk importing SalesOrders via SSIS - contactid not populating?

(0) Share

Report

Report

Posted on by Community Member

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Daniel Cai 935 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 164 Super User 2026 Season 1

#2

Jimmy Passeti 51 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans