A: 

And the answer is - Use SQL Server Integration Services with the SharePoint List Source and Destination widget from CodePlex

Hope this helps someone else out there.

matt eisenberg  2010-03-22 22:19:58

related questions

Using fields from a 'lookup-ed' sharepoint list
Sharepoint Conditional fields in Edit.aspx
Can we move SharePoint up in the site hierarchy?
Trimming DateTime format to Just Date format in CAML Query
How to have http module on fire events only for specific page types
Testing Workflow History Autocleanup
SharePoint Calendar List : Restrict entering second item with same From and To date
SharePoint - Custom Dataview - Link Rendering Issues
Why Does the Infopath 2007 Form Shows Error Message When Saving Repeating Table With More Than 60 Records?
Is there any good replacement for SharePoint Designer?
Whats the best way to create a Smart Part in SharePoint?
Howto get SharePoint version using object model
Sharepoint API - How to Upload files to Sharepoint Doc Library from ASP.NET Web Application
How to move documents from SharePoint 2003 to SharePoint 2007 with versioning?
Communicate with Document Library Browser Web Part
FileNotFoundException with the SPSite constructor. What's the problem?
Migrating MOSS 2007 from SQL 2000 to SQL 2005
Is it possible to attach a workflow to a task list on MOSS 2007?
Saving Word 2007 to MOSS gives never ending "Getting list of available content types..." dialog
MOSS 2007 Breadcrumb problem
Profile User DB error in WebPart
MOSS 2007 -- Invalid URL Exception SPSite.OpenWeb(...)
How can you hook a SharePoint 2007 feature into the Application_Start of a site?
Using ASP.Net 3.5 SP1 Routing with SharePoint 2007
How can I automate the process of deploying an InfoPath Form to SharePoint Server 2007?