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.