Data Flow Transactions

• BSavoie

  SSCertifiable

  Points: 6309

  More actions

  December 28, 2009 at 1:10 pm

  #215068

  I want to use a SQL Server Native Transaction in a package. I have a "data flow" that has an OLE DB Command that DELETES some data and it connects to another OLE DB command that INSERTS some data. I'd like both of those to be in a SQL Server Transaction. I understand how to create transactions in the "control flow", but I can't seem to figure out how to do it in the "data flow".

  Thanks!

  .

• sabyasm

  SSCarpal Tunnel

  Points: 4324

  More actions

  December 28, 2009 at 1:17 pm

  #1096807

  [font="Comic Sans MS"]

  Check this : http://www.mssqltips.com/tip.asp?tip=1585

  [/font]

  [font="Comic Sans MS"]--
  Sabya[/font]