SqlServer2005 datetime

[betterthanever]

Dear Gurus,
here is my problem.

i am trying to extract the data from sqlserver2005 table. the field is datetime field (ex: 2009-01-22 21:00:55.330).

i imported the metadata and the datatype is timestamp(23,3).

when i use view data ( using ODBC Eneterprise stage) the above time is showing as 2009-01-22 21:00:55 and the data is loaded to target sqlserver2005 table as 2009-01-22 21:00:55.000
i have to extract the milliseconds and i have to load the same values(.330) not (.000) for milliseconds field.


i tried changing the default format in the job properties to
%yyyy-%mm-%dd %hh:%nn:%ss:%SSS
but does not help.

Appreciate any help.

[kduke]

Extract as varchar and use a SQL Server function to convert back and forth from varchar to timestamp when reading and writing to the database.

[betterthanever]

[quote="kduke"]Extract as varchar and use a SQL Server function to convert back and forth from varchar to timestamp when reading and writing to the database. ...[/quote]

thanks for the reply but it does not work..