How to make a transaction in my case ?

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  November 8, 2013 at 12:47 pm

  #300119

  Let a person be defined by PersonID, a number. In my SSIS package, for each person, I first load some info into Table1 (with execute sql task) and then some info into Table2 (with execute sql task). I want this entire process to be considered as a transaction. That is, the transaction is complete only when information for A person is loaded both into Table1 and Table2.

  If we could not load info into Table2, then info already loaded in Table1 should not be committed.

  How do I do this ?

  Thanks.

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  November 8, 2013 at 1:50 pm

  #1665223

  Here is the answer -

  http://stackoverflow.com/questions/19867490/how-to-make-a-transaction-in-my-case