SSIS Help - SQL Server Forums

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources