DTSLookups Error

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  March 27, 2003 at 10:38 pm

  #452418

  I would guess that you are passing a value that is of a different variable type than what it expected by a parameter or a destination field.

  hth,

  Michael

  Michael Weiss

  
  Michael Weiss

• thyravi

  Old Hand

  Points: 369

  More actions

  March 28, 2003 at 4:27 am

  #452442

  Hi Michael,

  here is the query and code i have used. pls let me know

  Query:

  SELECT Name FROM emp WHERE (Sal = ?)

  DTSLookups:

  Dim myName

  Set myName = DTSLookups("My_Query").Execute(DTSSource("Sal").Value)

  Pls let me know where is the fault