A1VBCode Forums

Multiple Bulk Inserts


http://www.a1vbcode.com/vbforums/Topic30608.aspx

By davrook - 8/27/2011

i have a need to perform multiple bulk inserts into 3 different tables within a transaction so that if any 1 of the 3 fails then ALL are rolled back.

i have read up on this article which implies it can be done http://msdn.microsoft.com/en-us/library/tchktcdk(v=VS.90).aspx

but it doesnt really show how do what i need to do...

anyone any experience here would be greatly appreciated....