Search code examples
ssisdynamics-crmsql-server-data-toolsdata-migrationkingswaysoft

SSIS migration to Dynamics CRM 2016 (Kingsway soft/visual studio)

I am currently migrating some data from a holding database to dynamics CRM using SSIS/SSDT with Kingswaysoft plug in example. I currently have a field which stores the value as one line however I require the fields to be split up and migrated to the other three fields as well as leaving the value in the mapped field.

So for example: Storing Database (has data like this)
FIELD A:
ABC-123-321

I require the following once migrated to Dynamics CRM
FIELD A:
abc-123-321
FIELD B
ABC
FIELD C
123
FIELD D
321
So once there is a hyphen It should go the relevant field.

Solution

  • Managed to solve with the following expression.

    SUBSTRING(FIELDNAME,1,FINDSTRING(FIELDNAME,"-",1) - 1)