BEGIN TRAN w/ DTS question

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  December 17, 2008 at 1:11 pm

  #203059

  If I have the following query, what happens to anything performed in the DTS package and the tables ? Does the GO have any bearing on it ?

  begin tran

  update Table_A set flda = 1

  EXEC DTS_LoadTableB

  GO

  Update Table_C set fldc = 2

  rollback

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  December 18, 2008 at 11:34 am

  #914790

  i wrote an sp one time with begin tran, go and end tran and it caused blockings after the statement ran. never again. i don't use these anymore