vd
asked on
DTS - ActiveX script table lookup
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
Function Main()
DTSDestination("FinanceID" ) = DTSSource("Col001")
Main = DTSTransformStat_OK
End Function
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
Function Main()
DTSDestination("FinanceID"
Main = DTSTransformStat_OK
End Function
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER