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 |
|
drpkrupa
Yak Posting Veteran
74 Posts |
 Posted - 2006-10-06 : 15:16:14
|
| I am trying to create DTS package. We are getting data into csv (comma) format file from our client. I want a write DTS so it will grabe the data from this csv file and transfer into out database table.I create the source(csv file) and destination (sql database) connection and transfer data task between these two connection. It works fine.After three days we got error because client send us data with some duplicate data which they send us day before yesterday. On my tablel i have primary key for account no field and as soon as i got those duplicate record my pacakge get failed.How can i check data which we get in csv file is not in our table and only transfer which is new record.Thanks, |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-10-09 : 15:27:20
|
| Load everything into a staging table first, then perform validation on this before performing your final insert. You might want to think about performing the initial insert with a BULK INSERT rather than a DTS package.Mark |
 |
|
|
|
|
|
DTS Package