I was working on a project for the past few months, involving an InfoPath form to collect data, with a SharePoint Designer workflow and reporting handled by SSRS. We are populating reporting tables from the InfoPath form library fields using SharePoint web services and accessing them from within SSIS.
In business development studio, just add a script activity, modify the script (I chose c#) then add a reference to the web service, generate the proxy class, and make the call to get your list items.
I did not use the view fields xml, just left it blank to return all the fields. Amazingly, not all of the fields were returned. I thought this had to do with InfoPath, so I created a new field on the document library, and it was also not returned. So, after some testing, I found out that if the field is always empty, it is not returned in the results set. So, if this occurs, just create a temporary record with all the data in it, and generate you xml file, etc. from that.
Hope this helps.
-Dk