If you attended my TechDays session last week where I demonstrated how you can connect to SQL Server data and present it in SharePoint 2010, here is the video that shows how to do that: Bringing SQL data into SharePoint list in 8 min
The machine used in this demo can be downloaded from here: 2010 Information Worker Demonstration and Evaluation Virtual Machine (RTM)
Enjoy!