Hello, I am setting up an SSIS usingthe Sharepoint Source adapter. I am replacing and existing process that imports data from Sharepoint into Excel directly, but this is manual. The sharepoint source adapter seems to truncate column names or provides
different column names then what is visible on the user Sharepoin site - they all do not match my manual import into Excel and there are additional fields. I'd assume that what it is returning is the actual Sharepoint Database column name. Anyway,
I need to map my fields to my existing process in SQL. The only way I know how to do this and identify what columns are being returned, I am attempting to import the data into Excel using SSIS through the Excel Destination. I'm having an issue
with a few fileds....I have a field/column called QAReviews which is importing into Excel with all the fields for each record showing <Lon Text> instead of the value the Sharepoint site actually contains. In my manual Excel import process, this
field shows the correct data. By the way, on sharepoint this is a choice field. Can someone tell me why I'm getting something different through SSIS then what I get from using the manual import in Excel. I also exported the data from Sharepoint
to Access and again I get the correct data. Please advise.
View Complete Post