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&#34.Execute(DTSSource("HDR_JNL_END_DATE", "BILL_PERIOD&#34)

MYmonthId = DTSLookups(" FIND_BILLING_MONTH_ID&#34.Execute("MYMONTH&#34

DTSDestination("BILLING_MONTH_ID&#34 = MYmonthId
Main = DTSTransformStat_OK
End Function