I am migrating data to a Dynamic 365 database from a CSV file using flat file source in SSIS(kingswaysoft), most of have the data has migrated, but some fields failed. The error being that, it was trying map the column values close to the one it is meant to use to the field in in my D365 database. e.g, rather than map the "createdBy" field, it is trying to "permission to contact" field to the D365 Createdby field.
I have deleted the close by column and it still moves to the closest column, trying to map that one.
error code ",,,CON-115388,,,,,Dexter,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1,-1,KingswaySoft.IntegrationToolkit.DynamicsCrm.LookupFailureException: Text lookup failed for 'createdby' field, entity 'systemuser' does not contain a record that has a value of 'TRUE' for 'fullname' field (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.0.0.7160 - DtsDebugHost, v13.0.4495.10)"
I expect the Createdby to be mapped to the cretedby column in my Csv, but rather it is being mapped to a boolean column. I am such I mapped it properly in the flat file manager.
No, SSIS column mapping is not dynamic and you will need to set it manually. There is one caveat, however, and that is SSIS will automatically map columns where the column name matches.
I do not understand what you mean by the CreateBy column mapping to the "Permission to Contact" column. I do not think SSIS will do that automatically.