can dts do this or is there a better way of doing it i need to find out the bill the FIND_BILLING_MONTH form translation table1
the based on that result find the BILLING_MONTH_ID from table two
Function Main()
MYMONTH = DTSLookups(" FIND_BILLING_MONTH".Execute(DTSSource("HDR_JNL_END_DATE", "BILL_PERIOD")
MYmonthId = DTSLookups(" FIND_BILLING_MONTH_ID".Execute("MYMONTH"
DTSDestination("BILLING_MONTH_ID" = MYmonthId
Main = DTSTransformStat_OK
End Function