Forum Discussion

sanam's avatar
sanam
New Contributor
6 years ago

Snap sql server execute

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?

2 Replies

  • virender_prajap's avatar
    virender_prajap
    New Contributor III
    7 years ago

    In pipeline data value remain same before the oracle insert snap, value is getting changed in Oracle DB.
    But ideally it should insert value passed by pipeline only. Seems like in Oracle insert Snap…oracle timestamp is used which is generating this kind of problem.