I am trying to insert into a sharepoint list with SSIS and am getting an error which is to vague. I am trying to troubleshoot but just don't know enough about sharepoint. I have looked at the log files but there isn't anything there.

There are also a tonne of options under logging configuration....how would I trouble shoot permission errors, updating/inserting errors through logs or see what messages the connections are generating?

From SSIS side all I see is:

[SharePoint List Destination] Error: Error on row ID="1": 0x80070005 - Unspecified Error - Check SharePoint Server Logs if possible.

[SharePoint List Destination [131]] Error: Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.PipelineProcessException: Errors detected in this component - see SSIS Errors
   at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "SharePoint List Destination" (131) failed with error code 0x80131500 while processing input "Component Input" (141). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

Any direction would be very very appreciated.