I have a DB server running SQL 2008. I need to on a regular basis export a single table and then copy that table into a MySQL DB running on our remote web host.

SQL Server Migration Assistant for MySQL is the newest migration toolkit from Microsoft. Others are targeted at Oracle, Sybase, Access, and an analyzer for PowerBuilder.