CODEWITHSUNDEEP
ssisdynamics-crmcrmkingswaysoft
user3676641
user3676641

Reputation: 51

SSIS/KingswaySoft - Conditional Field Mapping

We have built a CRM integration using SSIS/KingswaySoft that it is currently importing Contacts and handing the Insert/Update "Upsert" logic based on a field value we store in our source table.

It looks similar to the the following...

enter image description here

The business has now requested that the "address1_city" field is brought in for Inserts and is ignored for Updates since they want City values on existing records in CRM to remain the same.

Is there a way we can conditionally apply the "address1_city" field mapping so it only runs for Inserts and not for Updates?

Upvotes: 0

Views: 58

Answers (1)

KingswaySoft
KingswaySoft

Reputation: 927

This would be a limitation of SSIS where the metadata would need to remain static and cannot be changed dynamically. You may need to implement a design where the records are conditionally split so that the respective paths perform either an insert or update. The field ‘address1_city’ would be mapped in the CRM Destination with the action Insert and excluded in the Destination component that has the Update action.

If you have any other questions, please reach out to our Support Team at kingswaysoft.com/about-us/contact-us and we will be happy to help or clarify.

Upvotes: 1

Related Questions