Update the Paradox table
I have a DTS Process in which I read the text file and based on certain data, I need to update some information in Paradox table. Can anyone give some idea on best approch to this?
Basically, the specific data is read from the text file and the corresponding Primary key is obtained from the SQL database. Now using this Primary Key, I need to update specific row in the paradox table.