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.
| Author |
Topic |
|
JJ297
Aged Yak Warrior
940 Posts |
 Posted - 2009-12-08 : 11:13:38
|
| I've added a DB Source and a conditional split onto my page. I want to remove duplicates from the SQL Source. How do I do this? I have 8 columns to see if there are duplicates there then remove them. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-08 : 11:40:52
|
| One way is to choose SQL statement as the source (instead of table/view) and write a query with SELECT DISTINCT to remove the duplicates.. |
 |
|
|
JJ297
Aged Yak Warrior
940 Posts |
Posted - 2009-12-08 : 13:33:54
|
| Thanks that did it! |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-08 : 13:39:29
|
You're welcome  |
|
|
|
|
|
|
Removing Duplicates in SSIS