Hello. Please HELP!!!! I've been trying to figure this out for a few days.
I am using the SSIS SharepointAdapters for 2005. When I pull data from my sharepoint site, for fileds that are choice fields in sharepoint are a datatype of DT_NTEXT w/4000 characters. The only thing in these fields is "PASS" "
"FAIL" and one filed has "QA Review Completed". When the data is imported into SQL these fields eiher show NULL or <Long Text>. I am using the combination of the Derived Column and Data Conversion to change the Datatype
of these fields from DT_NTEXT since no output will accept this datatype. I've tried exporting to Excel, Access and Flat files only to get same results. What I don't understand is if I import the data from Sharepoint to Access or Sharepont to Excel
using Sharepoint and not SSIS, I get the data that is in the field(s).
I've searched all over the internet and have not found where anyone has had the same issue which I find to be odd - I can't be the only one. I hope I'mnot.
PLEASE, PLEASE HELP!
View Complete Post