Download data from sharepoint using ssis

Download data from sharepoint using ssis

I am trying to download a list of columns from a published sharepoint. The
first issue I am running into it how to select a certain list of columns
from sharepoint. There are close to 100 columns and I need about 50
columns only in my task flow.
Second issue while just testing is that is throw an error message saying
that "[SharePoint List Source [1]] Error:
Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is
too large to fit in the column data area of the buffer. at
Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer.SetString(Int32
columnIndex, String value) at
Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32
outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100
wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr
ppBufferWirePacket)"
Beside there are few data conversion issue like converting DT_NTEXT which
I can do by converting to DT_WSTR using data conversion.
Any suggestions would be greatly appreciated as this is my first
sharepoint ssis package.