Obligatory MS Technet article - Creating a DTS package . . .

(Assuming SQL 2000 since we're in the 2000 forum)

http://technet.microsoft.com/en-us/library/cc917688.aspx

Rather than perform "all" the tasks on the fly . . .

you could split things up a bit . . .

i.e.

1.) Get the data into a table in the DB

2.) Use that newly imported data to update the other table(s)

Start off by using the DTS import wizard

- Open SQL Server Enterprise Manager

- Right click on the DB

- Select "All Tasks"

- Select "Import Data"

(run through the wizard and at the end - Save the DTS Package)

Navigate down the Enterprise Manager tree to "Data Transformation Services"

(and the package you just created/saved.)

Right click on the package and select "Design Package"

You'll see the graphical workspace . . .

(with the steps the wizard used to import the data . . . )

With data import task completed you can easily add in "Workflow"s & extra "Task"s to manipulate the data / perform jobs / etc.