Transfer data based on a condition

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  December 18, 2013 at 4:34 am

  #280455

  Hi all,

  I have to transfer data from Source to Destination based on a condition, how can I achieve this?

  Currently I took OLEDB as Source and after that I put a conditional split so that I can transfer data only for rows who has StatusFlag = 0 only and then I used OLEDB as Destination.

  Is it Ok or Do we can achieve this scenario in another way too?

  Thanks in advance....

  _______________________________________________________________
  To get quick answer follow this link:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• KS

  Hall of Fame

  Points: 3323

  More actions

  December 18, 2013 at 4:48 am

  #1674340

  I don't think you would require a conditional split in this scenario. Instead you can filter the required data at your source where StatusFlag = 0.

• Koen Verbeeck

  SSC Guru

  Points: 259125

  More actions

  December 18, 2013 at 4:49 am

  #1674342

  Please do not crosspost. It fragments replies and wastes peoples time.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1524028-2799-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP