Hi!
I am looking for suggestions on the best approach for separating records from one table to another. lets say from table "Case" and moving them to table "Business Case". There are currently records on the case table that have attachments. I was thinking of using an import set along with a transform map, this works perfectly because the table "Business Case" has the same fields as case since it is an extension of the "Case" table. My only roadblock is finding a way to also move along the attachments as well with the records.
What are you recommendations? Use a script on the transform map perhaps?
