If there is an error in XMLbulk insert, would all the data would rollback if the bulk insert is in transaction