Post reply

DTSLookups Error

  • March 27, 2003 at 10:19 pm

    #105897

    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.)

    Thanx

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply