I’m trying CData SSIS SharePoint Components for the first time.
I’m following the tutorial instructions to from CData to insert new or update existing records in SharePoint.
Using SQL Server (2012) as a source, I am attempting to setup a CData SharePoint Lookup task, but cannot map an ID (int) column to the ID (number) column on SharePoint (2016). Apparently a number with 0 decimal places is a datatype DT_R8, so I cannot map these columns, as DT_R8 cannot be used to map due to not being exact.
I don’t see any particular option in SharePoint to make a number not a float.
It does seem a bit odd that there’s no way to map on a SharePoint number column, so maybe I’m missing something, or perhaps it’s because it’s SharePoint 2016.
Since I can map on text, I can modify my own SharePoint lists to use text columns, but it may not be so easy to get business partners to modify their lists to add an identical number column using a text data type.
Best answer by Ankit SinghView original