The "flat file" approach wasn't ruled out as such I was just under the impression it might be better to export the data as XML to maintain the parent/child hierarchy...

John, thanks for the prompt replies and assistance so far.

Just thinking a little more about this "cleansing" table.

As the TransactionID as provided by the Branch would otherwise be...

I guess in a way it is akin to a data warehouse however there is no CUBE/Analysis data being generated for reporting only purposes. This database is the same...