DTSLookups Error

• thyravi

  Old Hand

  Points: 339

  More actions

  March 30, 2003 at 6:56 pm

  #105604

  Hi All,

  Using the DTS designer, i tried an ActiveX script using DTSLookups, it fails with the message that there is a "type mismatch: DTSLookups".

  Why this error comes and how to rectify it?(I have SP 2.)

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

  Query:

  SELECT Name FROM emp WHERE (Sal = ?)

  Script:

  Dim myName

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

  Pls let me know where & what is the fault

  Thanx

• April 2, 2003 at 8:00 am

  This was removed by the editor as SPAM

• jfb

  SSCrazy

  Points: 2469

  More actions

  April 2, 2003 at 12:57 pm

  #452896

  Hi,

  Take out "set"

  Dim myName

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

  Is this an array? Then

  DTSDestination("col001")= myName(0)

  DTSDestination("col002")= myName(1)

  ...

  Johnny