Unable to execute DTSLookup

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.