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 - 2001-03-06 : 11:30:18
|
Young writes "Text delimited file is being downloaded to my SQL Server 2 times a day. I have created DTS to import the downloaded Text delimited file 2 times a day. once at 7:30 am and other at 1pm.
The problem I am having is a duplicate records. The Text Delimited file that is downloaded in the morning has a sales record of all the stores and one in afternoon has all the records that were in morning download plus new records.
When DTS imports the afternoon record, it's importing new record as well as duplicate records. I tried to index my table to ignor duplicate record. unfortunately, none of the fields that are in my table is unique.
My Table:
Dat|store|dept|netsales|division#|
What can I do to get rid of the duplicate record automatically ??
Thanks
YJK" |
|
|
|
|
|
DTS