I have the following transformation defined for a source
and destination column:

Function Main()
IF DTSSource("EMP'MARITAL") = "M" THEN
DTSDestination("empTaxCategory") =
DTSLookups("TaxCategoryLookup").Execute("Married-Filing
Jointly")
ELSE
DTSDestination("empTaxCategory") =
DTSLookups.Item("TaxCategoryLookup").Execute("Sing le")
END IF
Main = DTSTransformStat_OK
End Function


When I test the transform, I get an error message that
says: Error Description, Object Required: DTSLookups

that is, there is no DTSLookups collection. Everything I
read (sqldts.com, msdn, msKB) says the syntax is as above.

SQL 7.00.623 on NT 4, sp 6

Need a solution, need to know what I am missing.
Thanks
Bruce

In article <012201c39035$46557d20$a401280a (AT) phx (DOT) gbl>, Bruce Hanson II
<bhanson2 (AT) metronet (DOT) com> writes
You actually have two different syntax calls, DTSLookups.Item and
DTSLookups. Both should work, but I have never used the Item method
myself.

Are your sure the lookup name is correct, TaxCategoryLookup?

Which lines does it error on?



--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org