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 - 2002-09-04 : 11:31:18
|
| neel writes "I've a text file and I need to import it to a table. I can do this using Import/Export task, but before updating the table I need to check that the perticular Row (can say record) already exists in the destination table, if exists need to update the record else insert the record. How can i do this. I need to do this task every day and the text file can contain more than 10,00,000 rows. could you please tell me indetail..ThanksNeel." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-09-04 : 13:24:16
|
| I would use a non-logged operation to import the data into a 'staging' table, the INSERT/UPDATE you final destination using DML ...Jay White{0} |
 |
|
|
|
|
|
Importing text file with some updates