Just a follow up.. I think I've solved this problem.

I've modified the original template to query the new import table, look up the new post number, and then redirect 301 directly to the new URL, bypassing the site_id=1 thing.