Hello,

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.

Thanks,

Create a connection to your Pardox table and use a Execute SQL Task or a Data Driven Query Task.