you can handle the DBTYPE_DBTIMESTAMP conversion of datetime to SQL Server timestamp in DTS Transform task using activex script

thanks i have done it by moving to temp table and then using stored procedure in the destination side to move data from one table to another.

thanks for the input.

gans

...