When I use dts to export from my sql server 7.0 database to a text file all of my date fields have 9 characters to the right of the decimal in the seconds. For example, my dates in the text file look like 2002-02-12 15:25:44.030000000 Is there a simple way to truncate this to hh:mm:ss.sss format? My date fields are all defined as datetime format in sql server.
I figured out what to do. I used the sql query option instead of the table name option to select the table columns and used a convert(varchar, date, 121) x, to convert the date column.