migrating existing MS SQL DB to DRUPAL.

I have an existing CF site with thousands of nodes on an MSSQL DB. I am starting from scratch on a new DRUPAL site that will replace the CF site. I would like to figure out some way to automatically migrate the MSSQL DB into the mysql system.

Mentally, I know how the fields will translate to the new CONTENT TYPE. And when I build my MSSQL query, I can probably just manufacture the new fields in the SQL QUERY. I was thinking that perhaps just creating a coma delimited flat file would be a good choose to import the new fields. But I am curious if someone has already tackled this problem before?
There are some nodes with Images that also would be imported. But we can skip the images if it complicates things to much.
thanks