Hi,
my source data is like 2007-10-30 12:48:16.300 i have laoded in to target but data getting like 2007-10-30 12:48:16.000.I am doing simple job MSSQL table1 to MSSQLtable2.i metnioned datatype is timestamp in both source and target.but i am not getting correct data in target ..
Thanks
sasidhar
timestamp issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
I actually think that this is the bad data the OP is referring to, although it is difficult to discern really from the orignal post.
To the OP - Please right click on the row (column) in your columns tab and choose "Edit Row" and then verify that the "Extended" (Microseconds) has been selected.
I aslo believe that someone posted and said to set the extended properties of the column, but I think the op thinks that means to set the field to length 23 and scale 3 which would give the results above if the extended properties are not set for microseconds.my source data is like 2007-10-30 12:48:16.300 i have laoded in to target but data getting like 2007-10-30 12:48:16.000
To the OP - Please right click on the row (column) in your columns tab and choose "Edit Row" and then verify that the "Extended" (Microseconds) has been selected.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com