Can I alter the following ActiveX script to
take the value currently in DTSDestination (an integer),
look up a name from a reference table and store that name
instead of the reference number to the destination table?
' Copy each source column to the destination column
DTSDestination("FinanceID") = DTSSource("Col001")
Main = DTSTransformStat_OK