Home Forums Data Warehousing Data Transformation Services (DTS) TRANSFORMING DATE USING DTS RE: TRANSFORMING DATE USING DTS
David Burrows
SSC Guru
Points: 65111
More actions
July 29, 2003 at 6:44 am
#467457
Define your output columns on your target table.
Set transformations for all other matching columns.
Create ActiveX script to parse the input date to the separate output columns.
Far away is close at hand in the images of elsewhere. Anon.