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 : 12:19:29
|
| I am trying to create DTS package. We are getting data into csv (comma) format 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 and destination connection and transfer data task between these two connection. It works fine.After three days we got error because user send us data with some duplicate data which they send us day before yesterday. So 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 out table and only transfer which is new record.Thanks, |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-10-09 : 15:35:58
|
| Duplicate post [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73177[/url]Mark |
 |
|
|
|
|
|
New in DTS Package