Hello.

I am making a Transactional Replication with DTS transformation. We
tried to use Lookups in the DTS package and the result is "Variable is
undefined: 'DTSLookups'"

This is the code:
OPTION explicit
Function Main()
DTSDestination("FkClient") =
DTSLookups("SearchIdClient").Execute(DTSSource("Cu stomerId"))
Main = DTSTransformstat_OK
End Function

When I test the Lookup at design time it works correctly and returns the
correct value for the select clause.

If I do not use OPTION explicit then the error is: "Type Mismatch:
'DTSLookups'"

If I use JScript then the error is: "object expected"

Any idea?

Thanks.
Gabriel