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 |
|
sqldba2k6
Posting Yak Master
176 Posts |
 Posted - 2007-04-10 : 22:37:43
|
| I want to delete the duplicate records in a flat file(.csv).and want to export the cleansed data to sqlserver 2000 database.Please help me in writing the DTS package with the above condition...THanks for your help in advance!!!!!!! |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-04-11 : 03:51:33
|
| Import the flat file into a staging table and use a query / stored proc within an execute sql task to write deduped resultset to your destination table.Mark |
 |
|
|
|
|
|
DTS package Help