Does SQLCmd step support atomic transaction?

https://developer.ibm.com/urbancode/plugindoc/ibmucd/microsoft-sql-server-sqlcmd-2/1-2/

The above step, if I have multiple scripts in the “SQL Files” field, are they going to be run in an atomic transaction? Means in either all occur, or nothing occurs. e.g. if there are 5 scripts, and fails on the 3rd, then 1&2 won’t be committed?

Related:

Leave a Reply