not knowing all whats happening with your tables it hard to give a good answer but....

first off...

if your changing data that points to another table (foreign key FK) you have...

i would think a table logging would be the best approach as the Global Variable within the DTS Package is unique to the instance of the package

you could also have...

example of how doing this within tsql:

CREATE TABLE #Temp1 (

Field1IntNULL,

Field2 VarChar(64)NULL)

BULK INSERT #Temp1

FROM '\\server\share\folder\filename1.csv'

WITH

(

...