Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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
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.
Business Applications communities