SQL2000 - DTS copy issues

[dilbert]

Hi All,

I have a specific problem with DTS.

I am transferring data from a db instance to another on SQL 2000. The source and destination instances both have a Datetime field. When i map these fields:

Main ()
Source.datetime= destination.datetime

The DTS does not copy the value of source datetime into the destination but copies the current datetime into the destination.

For e.g. the source timestamp = '12/08/2009 12:00:00'. When the DTS is run (let say at 13/08/2009 04:00:00). It inserts '13/08/2009 04:00:00 into the destination datetime field. I want it to insert '12/08/2009 12:00:00' instead.

What have i done incorrectly?

Please advice

[rmiao]

How did you transfer data? With query?