Is this something SSIS can do easily? I know it can transform fields and all that but I've not seen any examples of it doing what I am setting out to do.