Simple DTS?

[eggy168]

The DTS has been working, but I want to add a column (SQLtime with Timestamp as the Data Type or the Data Type is wrong?) in the destination table that includes the Time that record the DTS finishing time.

The DTS is a simple Select statement that copy data from Table A from Server One to Table B to Server B with all the columns are matching. It started from Truncated the destination table, then used the Transform Data Task where the Select statement is written. Once I run the DTS package, the column, SQLtime is null.

Can anyone helps or guide me to make it works? Thank you.

 

[RiverGuy]

You don't want to use a Timestamp data type. You want to use DateTime or SmallDateTime. But, you need to get a value into your new field. Try modifying your source query as such:

DECLARE @CurrTime DATETIME
SELECT @CurrTime = GETDATE()
SELECT *, @CurrTime AS CurrTime FROM TableA

Then, in your Transform Data Task, map the new CurrTime field from your source query to your SQLtime in your destination.

 

[eggy168]

It works now. Thank you very much RiverGuy.