Ordering of Server behaviors is something DW isn't that great at. The reality is that the recordsets will always be placed above. In some cases you want them above and in some cases you want them below. The only solution is to cut and paste, cutting and pasting recordsets is usually the only thing you need to move, but applying in a different order won't prevent that issue.
Manage Relational Table is basically a combination of multiple insert and update, not sure what you are doing but it may be applicable for you.
If not, I'm sure you could combine them as well, but I'd have to try it once to figure out the particulars and I can't quite diagnose the problem from your description alone.
Did this help? Tips are appreciated...
