Nov 19, 2009 at 12:31 AM
Edited Nov 19, 2009 at 12:32 AM
As a follow up on this, I came across another reason to use this SSIS SharePoint adapter, with the variation on the SharePoint destination datatype.
Need: mapping from a SQL numeric(13,2) -> SharePoint
In SharePoint, I see currency's underlying datatype once again is DT_R8 - revealed inside the SSIS advanced properties of the SharePoint List Source, External Columns > DataType section. It'd been a while since touching this part of the solution,
so I had to retrace my original solution posted above. As it turns out:
Solution: in SQL prior to retrieving the numeric column using the OLE DB source, convert the column into a float --
cast(column1 as float)
Afterwards, in SSIS make sure to remove the outbound OLE-DB source mapping & re-add the mapping (so it pulls the correct float/DT_R8 datatype) or edit the advanced properties on the green data flow coming from the OLE-DB source, then edit the datatype
of the specific Output Column.
I'll post the complete SSIS walkthrough with glorious pictures on my blog;
& thanks for the community contribution Kevin.