Home Forums Data Warehousing Data Transformation Services (DTS) break up a NAME col into FNAME, LNAME cols RE: break up a NAME col into FNAME, LNAME cols

  • November 12, 2003 at 2:45 pm

    #481777

    Are you doing an Active X?

    If so you could try spliting the string on the commas into an array.

    arryTemp=split(NameField,",")

    Any chance to have the file better formatted before it gets to you?