I am in the process of converting a DTS package into SSIS. That DTS package has an ActiveX script that references a DTS Lookup. The code looks something like the following:
myid = DTSLookups("GetSomeId").Execute("DTSSource(variable1, variable2)
Is it possible to have the Script Component reference a lookup task?