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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-20 : 08:24:10
|
| just writes "Using a text file i am uploading data into two tables Customer_Master and Customer_Details. But there are some duplicate records in the text file which are already present in the Customer_master table, so How to skip these duplicate records insertion by DTS Package?" |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-09-20 : 11:40:12
|
| Upload your text file into a holding table, then insert from here using T-SQL. This enables you to easily eliminate existing rows from your insert via an outer join from the holding table to the destination table.Mark |
 |
|
|
|
|
|
DTS