Hi john
Data Transformation Services (DTS) It allow your transform data from one to source to another. That is just one of its feature. Might as well try it. You can also run SQL script , and VB Scripts. I used it when migrating my old data to new Structure.
Roses are #FF0000 Violets are #0000FF all my base are belong to you