Hi,

I have a question, how can I export the table into a csv file and couple
column need merge into a column while export to the csv file.
Source colume: partno,material, color, grid, screen
CSV file: partno, types

Thanks,

Dannie

In DTS use an activeX transformation and create it so that the destination
is a concatination of multiple source columns.

IE
DTSDestination("Partno") = DTSource("Partno").Value
DTSDestination("types") = DTSource("Material").Value &
DTSource("color").Value & DTSource("grid").Value & DTSource("screen").Value

You'll have to add the formatting (such as "-" in between column values if
they are required) but this is the general idea.

"Dannie Chan" <DannieChan (AT) discussions (DOT) microsoft.com> wrote