That is exactly what I ended up doing.  I made a temp table as a holding tank for the data, then do all my transforming to the necessary tables.

Thanks for...