06-18-2020 12:48 AM
Hi Team,
when i write two statement in sql server execute snap. e.g first is truncate table and then load table it does not error out if the second sql statement fails.
Can you please let ,me know if there is any way to make the snap fail if any sql statements have errors?
06-18-2020 09:49 AM
Welcome back, @sanam
A couple of suggestions have been proposed around the virtual water cooler today 🙂
06-18-2020 11:05 AM
it will be great if I could put two sqls in one execute and handle the errors.
for simple steps it really make my pipeline long.
Thankyou for the prompt reply.