title: How to set Rollback in case of Error in Talend?
body: <p>I have a Talend Project, that Synchronize two tables by :</p>
  
  <ol>
  <li><code>DELETE TABLE 1</code></li>
  <li><code>SELECT * TABLE 2</code></li>
  <li><code>INSERT TABLE 1</code></li>
  </ol>
  
  <p>look at photo down below.</p>
  
  <p>Imagine, two first steps go fine, but at final step (insertion) it throws an error. Can I restore deleted rows, that were executed on the very first step?</p>
  
  <p>And how <code>tMSSqlRollback</code> works anyway? I tried in vain to set it up. (There're no components in "List of components" drop down list, in 'Simple parameter' tab.</p>
  
  <p><img src="https://i.stack.imgur.com/pYrwe.jpg" alt="Talend project photo"> </p>