Snap sql server execute

Question

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?

dmiller · Answer

Welcome back, @sanam
A couple of suggestions have been proposed around the virtual water cooler today 🙂

Have one execution per Snap, as this makes troubleshooting easier. It also makes the pipeline easier to read if someone new has to pick it up.
drop these into a sub-pipeline, where they can still be executed as individual Snaps, but the errors could be handled separately.  This would have the advantage of being still just a single step in the parent pipeline.

sanam · Answer

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.

Forum Discussion

Snap sql server execute

2 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found