In your DTS package create the tasks to import the data from the text file
into a table in the SQL Server database. Then you can create additional
Execute SQL Tasks in the same DTS package to perform the transformation
needed. Based on the information you provided in your first email an
example could be:
In the same DTS package:
1. Perform a Bulk Insert Task to import the data from the text file into a
table that has the SQLKeyId and UpdateKey columns.
2. Then perform an Execute SQL Task that performs the UPDATE against the
existing table and then drops the temp table.
If all you need to do is perform SQL update statements once the data has
been imported into a temporary table then it is not necessary to use
ActiveX for these type of operations - Execute SQL Tasks are appropriate
and can all be done in the same DTS package.
For more information on using the DTS Designer and setting up packages with
different tasks, please see SQL Server Books On-Line -> DTS Designer and
the topics DTS Package Management, Saving a DTS Package and DTS Package
Microsoft SQL Server Support