AKA Integrating SharePoint Lists and SQL Databases without needing the Business Data Catalogue.
Thanks to one of my customers for pointing this out to me -
Integration Services package developers often ask about the best way to get data out of or into a SharePoint list. The SharePoint List Source and Destination Sample available on the Microsoft SQL Server Community Samples: Integration Services page on Codeplex provides an optimized solution with an easy-to-use interface. The sample also includes an API for accomplishing these tasks efficiently outside of Integration Services.
For more information go to Extracting and Loading SharePoint Data in SQL Server Integration Services