That's the way the transaction should work, if something doesn't work, ALL FAILS. That way you can correct the problem and resend the whole transaction without having to find the rows that didn't work and resend only those, which may be a lot more complicated case to handle.