SQL Server Performance

Unable to execute DTSLookup

Discussion in 'SQL Server DTS-Related Questions' started by cbuhi, Feb 22, 2006.

  1. cbuhi New Member

    I have a pretty simple lookup query that returns an error that I can't figure out. It states that the query has too few parameters (2), but only 1 is required. I've investigated every component and everything seems correct. I have another lookup just like this and it works fine. Here is a simple description:

    I have an Access table with values that have to be loaded into a SQL Server table. I defined a Row Transform task with an ActiveX script.

    My lookup query is called Test1 and looks like this:

    SELECT ConveyanceInstrumentId
    FROM ConveyanceInstrumentMapping
    WHERE (conveyanceinstrument = ?)

    Here is the transform script:

    '**********************************************************************
    ' Visual Basic Transformation Script
    '************************************************************************

    ' Copy each source column to the destination column
    Function Main()
    dtsdestination("ConveyanceInstrumentId") = DTSLookups("test1").Execute(1)
    Main = DTSTransformStat_OK
    End Function

    The Execute(1) is just there for testing purposes, but returns the same error as when I reference the field I want to look up.

    When I test this, an error is returned: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2

    Any suggestions or ideas are appreciated.

Share This Page