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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!