Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Help

Author  Topic 

tooba
Posting Yak Master

224 Posts

Posted - 2015-05-06 : 13:50:17
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.
   

- Advertisement -