570
HI,
I am doing data migration from Excel sheet to CRM 365 using Kingsway.
I am getting 'Yes', 'No' for two options field, when i am mapping it to crm boolean field i am getting error.
Can someone let me know how to map 'Yes' 'No' to CRM boolean field.
Thanks
*This post is locked for comments
Thanks Adrian,
It solved the issue.
Hi bala krishna,
That is what I am suggesting. You will need to write an expression for each conversion in your Derived Column Transformation Editor.
(DT_BOOL)(ColumnName == "Yes" ? 1 : 0)
Hi Adrian,
I tried to type cast using Data Conversion component in SSIS but i get error from import as 'Data conversion value is 4, cannot truncate...etc'.
Are you suggesting something like this in derived column,
[field]=="Yes"?(DT_Bool)1:(DT_Bool)0
If i have 15 boolean fields, do i need to write for all of these?
Hi bala krishna,
You need to convert your "Yes" and "No" String values to Boolean values by using a Derived Column Transformation in SSIS.
Error info:
System.Exception: Error: Failed to set field 'new_police' value to 'No' for entity 'new_abc' (field type: Boolean, value type: String). System.FormatException: String was not recognized as a valid Boolean. (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6972 - DtsDebugHost, v14.0.3002.107) (SSIS Integration Toolkit for Microsoft Dynamics 365, v10.2.0.6972 - DtsDebugHost, v14.0.3002.107)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (