I have a table that allows duplicate part numbers to be inserted because each part can have multiple locations example:

part_no locale
123abc London
123abc Paris
123abc Madrid

I need the DTS package to import from the source the duplicate part number with the assigned unique location name. In my VBscript I seem to be only able to add one unique row at a time. Here is the script:

Function Main()
    DTSDestination("part_no") = DTSSource("ItemNumber")
    DTSDestination("locale") = "CA PUBLIC"

End Function

I have thought of creating a DDQ but seems way too involved for what I need to do.

Any ideas?
How do I do this?

Realgone

How is the your "destination" column define?

Is itemNumber a primary key?

Jaime E. Maccou