Update - August 2, 2010

Support for specifying credentials in addition to using integrated security was rolled into the main package. Currently, it's in beta, and it can be downloaded from here (named "BetaSharePointListAdaptersSetup.msi" under "Other Available Downloads").

My project is unneeded now, and will probably be deleted from Codeplex soon.

On a project at work recently, we needed to create a report using SharePoint list data. We decided to use SQL Server Integration Services (SSIS), and looked at using these SharePoint list source and destination adapters on CodePlex. However, these sample adapters only supported Windows integrated authentication, so I modified them to accept basic authentication.

I've created a project on CodePlex for these modified source and destination adapters, and also put together a simple release with the pre-built assemblies and simple instructions.

I hope this helps someone who has a similar problem.