Hello,
If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still continue getting inserted into the table.
I want it to be the case where either all 3 records are inserted into the table, or if at least 1 record gets an error then none of the records get inserted.
Thanks