Unanswered: How to update record & insert the record?
I am a beginner sql 2000 user, I would like to have your help, please.
I need to import txt file to sql 2000 table daily, so I created DTS package.
I want to update the existining record and also insert the record if there are any changes in the input txtx file. Where in DTS package, I can have these conditons? Could someone show me some example code?
I want to update the existining record and also insert the record if there are any changes in the input txtx file.
Do you mean that you have a text file to import that reconciles against an existing database and only update records that currently exist and insert new records ? Where is this data originating - from another db ... ?
The text file is in server (shared server by the group). The file is refreshed by the mainframe job daily. The text file contains last three months of data - most records remain same but some fields in some records maybe updated daily.
I need to import the text file daily to refresh the table.