timestamp issue

vinsashi · Post by **vinsashi** » Mon Sep 13, 2010 3:36 am

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

priyadarshikunal · Post by **priyadarshikunal** » Mon Sep 13, 2010 3:53 am

Try using extended property microsecond also you may need to define the precision to number of digits in microsecond part.

vinsashi · Post by **vinsashi** » Mon Sep 13, 2010 3:59 am

Yes I have mentioned length as 23 and scale as 3 but i am getting same prob any solution for this.I am using source and target are ODBC stage.

chulett · Post by **chulett** » Mon Sep 13, 2010 6:25 am

"Not getting correct data" isn't all that helpful. What exactly are you getting in your target?

mhester · Post by **mhester** » Mon Sep 13, 2010 6:36 am

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.

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 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.

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.

chulett · Post by **chulett** » Mon Sep 13, 2010 7:26 am

Sorry, looks like I missed the example in the original post.