I am new to DTS but I have quickly found that it is very
Powerful. I have started building my transform that
inserts records into a "holding" table. I need to check
to see if an ID exists in another table. If it does get
the values from 3 fields if not then use some constant
values. I started to write my own function but then found
Lookups thank goodness), and a very good site
www.sqldts.com. My question is what happens if the lookup
returns an empty recordset and how would I trap that? I
know I will get an array if a record is found but is an
error thrown with an empty rs on the execute method?

Craig

Does ISEMPTY() meet your needs ?

--

----------------------------
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



"Craig Sanborn" <csanborn (AT) asbuilts (DOT) com> wrote

It does. That's how I ended up writing it. It's just at
the time it seemed to simple :-)

Thanks for the reply and the good stuff on SQLDTS.com

Craig