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 |
|
RobinM
Starting Member
7 Posts |
 Posted - 2009-03-09 : 12:34:09
|
| I have a file that I need to import once per week via DTS. My DTS is working and importing the file but the problem is, it is appending the data instead of overwriting the data. In other words, the file has approx. 76,000 rows. I only want to import the additional 50 rows that were added since the last time I imported, but instead it appends the whole 76, 050 rows so now I have a bunch of duplicates and the total rows is now 152020. Isn't there a setting or option somewhere that allows you to choose whether to append the data or overwrite the data? Any suggestions would be appreciated. Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 12:37:15
|
| You have to write a Logic for that. Like in SSIS, they have Lookup Transformation task. You should write to insert IF not exists and update IF EXISTS. |
 |
|
|
|
|
|
DTS-Append vs. Overwrite