Now Reading: 00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog
1
-
01
00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog
We got the below while trying to UPSERT contact records from a SQL table to Dynamics 365 CE using Kingswaysoft Dynamics 365 Adapter.
The source table had the Date of birth (DOB) as nvarchar type (string) and one of the rows had the following value stored for DOB à
‘0201-01-09 00:00:00’
Which was resulting into exception while creating record inside Dynamics 365 CE with the above date.
The way we fixed it was to make use of
Derived Column
à Converting empty string to null for DOB…
Continue Reading Nishant Rana’s Article on their blog
00 in SSIS (Dynamics 365) – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission
Top Headlines
Support The Site
