SSIS Help

• tooba111

  Right there with Babe

  Points: 767

  More actions

  May 6, 2015 at 11:50 am

  #303605

  Hi Guys,

  I need urgent help Please.

  I have source data sample below.

  ID,FNAME,STATE

  1,CHRIS,NY

  2,JAMES,CA

  1,SMITH,CA

  3,NORMAN,NY

  Here is my Destination should Look like

  ID,FNAME,STATE,Trigger

  1,CHRIS,NY,1

  2,JAMES,CA,1

  1,SMITH,CA,0

  3,NORMAN,NY,1

  Question: - I want to know how I can accomplish this thing in SSIS. Logic I am using, if ID is duplicate Trigger only first time, rest should be '0' ( If there is duplicate IDs)

  Please advise.

  Thank You.