Home Forums Data Warehousing Data Transformation Services (DTS) TRANSFORMING DATE USING DTS RE: TRANSFORMING DATE USING DTS

  • 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.