Currently you have to build a temp table then insert values from that to the underlying sources and still have no way to get the transaction status back to the requesting agent. We should auto generate a simple transformation and include the code to return the value of the "rows committed" back to the client