Can anyone offer assistance in being able to export and transform a 'DateTimeStamp' field using the DTS tool in MS Sql Server 2000. All exportation and transformation to varying destinations do not transfer the complete DateTimeStamp ie. "23/5/2005 22:10:03" transforms to be "23/5/2005 22:10" and all seconds entries are lost.
Any ideas on ways to export and transfer a 'DateTimeStamp' exactly as it is represented in sql 2000? I want ot export to a .csv or similar.