Since the release of SQL Server 2005 Integration Services, there has been an unanticipated amount of interest in reading and writing SharePoint data from SSIS packages.
Microsoft developer Kevin Idzi recently filled this need by releasing the SharePoint List Source and Destination components on the Microsoft SQL Server Community Samples: Integration Services site on Codeplex. Kevin also deserves a lot of credit for aggressively fixing bugs, adding features, and responding to customer comments and issues.
Recently Kevin wrote up an article with screen shots that explains the features and properties of the SharePoint List source and destination, and walks you through setting them up. You'll find that article here:
Extracting and Loading SharePoint Data in SQL Server Integration Services
Don't overlook the fact that the download of the SharePoint components includes a standalone DLL, SharePointUtility.dll, that encapsulates most of the non-SSIS-specific functionality of the source and destination. You can call this assembly from any managed programming project to perform some common SharePoint activities more easily than by using the SharePoint APIs directly.