Hi Dude,

in server 2000,we have excel 97-2000 tranformation is there...

Go to that that transformation ,select file location

then drag and drop database transformation,in this transformation,give the ur database name

and link to this two transformations

in this link ...goto properties select source and destination

u have anthoer transformation execute sql stmt..in that one write the

query

IF EXISTS(SELECT *

FROM Production.Product

WHERE ProductNumber = @ProductNumber)

UPDATE Production.Product

SET NAME = @ProductName, StandardCost = @StdCost

WHERE ProductNumber = @ProductNumber

ELSE

INSERT INTO Production.Product

(Name, ProductNumber, StandardCost)

SELECT @ProductName

,@ProductNumber

,@StdCost

and the DTS

Thanks,

Pathiapti