I had a similar problem. It wasn't due to several connections, but rather to scope issues - the transformation didn't have access to the temp table because it was out of scope ie had been committed, so I used global temporary tables whose name was guaranteed to be unique per user.