Hi

I am new to DTS. I have trying to use Lookup in the
Transform Data Task to retrieve 2 column from a table. The
look looks like this

select field_1, field_2 from test_table where field_3 = ?

Then in the ActiveX scripting windows, I have declared a
dim variable (called it arrFields).

dim arrFields

arrFields = DTSLookups("LKP_test").Execute(DTSSource
("Field_ID"))

Its seems to work initially, however, when one or both the
return data (field_1 or field_2) is NULL, it gives error.

How to overcome this. To continue testing, I have done a
lousy work around or splitting it into 2 looksups which is
making the system very slow.

Hope I can get some advise on this.

Thank you very much

Yew Loon

Have a look at this article and the ISEMPTY() function

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277,1)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"YewLoon" <yewloon_wong (AT) sg (DOT) firstapex.com> wrote