I have a table that allows duplicate part numbers to be inserted because each part can have multiple locations example:
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:
DTSDestination("part_no") = DTSSource("ItemNumber")
DTSDestination("locale") = "CA PUBLIC"
I have thought of creating a DDQ but seems way too involved for what I need to do.
How do I do this?