I have done this several times. I used DTS to pull the data in. My Preference is to pull the data in table-for-table, and then, if my SQL tables are different/redesigned, I like to use stored procs to put data from the imported tables into the newly designed tables.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.