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 - 2003-07-23 : 07:34:26
|
| Shawn writes "I apologize if this is on the forum or in the faq's. The problem i am having is i have a text file that continually gets updated. I also have a sql table that needs to get the updated information from the text file, without duplicating the information on the sql table. I have gotten it to run with importing the text file into my sql table. But when the txt file is updated i get confused because i can not get the sql table to only take the updates it needs from the text file. I have tried working with the insert and update and just can not get it to work correctly.Any help would be appreciated.Thanks" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-23 : 15:50:23
|
| Can you post the ddl of your table?What you need to set up is a delta process...finding out what's new, gone or changed.I'm assuming you can't just blow away the data in the table and just reload it? Because of updates to the data?Brett8-) |
 |
|
|
|
|
|
Preventing Duplicate files and using Text Files