DTSLookup type mismatch problem

[harpsw]

I need some help getting a DTS Lookup to work.

Using SQL Sever 7.0, my data source is a text file.
One of the fields is a date (text data type). In
addition to loading this date (which works fine), I
need to set a second field to the fiscal month of this
date. Since we run on a 4-4-5 fiscal period, I have
another table that contains the crossref of dates and
fiscal months. I created a DTS lookup using a separate
connection:

SELECT FYMTHNBR
FROM CONVERTDATES
WHERE (DATE = ?)

The activex script for the fiscal month column is:

DTSDestination("FYMTHSHIPBY&quot = DTSLookups("GetFYMth&quot.Execute(DTSSource("Col004&quot.Value)
Main = DTSTransformStat_OK

I only get a Type Mismatch: 'DTSLookups'

FYI - I've changed all involved fields to type CHAR and still received the error.

Any help would be appreciated.