Using a Console App to Extract a data from sharepoint list
<p>I have been searching for hours about the best way to do this and all I find is massively conflicting information and im at the point of breaking down.</p>

<p>I have a sharepoint 2013 site which naturally has a list on.</p>

<p>I wish to connect to this list and extract the information into a data table. shouldn't be that hard should it...</p>

<p>So options I have tried, 
I was originally planning on ssis to pull the information and transform it prior to its final destination. 
There is a great little adapter apparently for this the sharepoint list adapter... doesn't work with SSIS 13 !!! of course it doesn't that's the only version I can use.</p>

<p>So then I read up on a webservice called lists.asmx which when called and queried should return an xml version of the table... great! </p>

<p>I connect to the webservice and the one method that I need to use (GETLISTITEMS) which is in all the tutorials doesn't exist in SP2013!!!</p>

<p>can someone please give me an example or link me to a website which shows connection and query examples of either</p>

<p>A pulling the data via SSIS 13 
B how to connect to the SP site and extract a tables information.</p>

<p>Please return my sanity, Thank you</p>