I need to:
1. Retrieve a subset of data based on data from each source record.
2. Perform some analysis on this data.
3. Set a value in the destination based on this analysis.

I'm fairly new to DTS, but after a little research I thought I was on
to something with the Lookup feature. After struggling trying to get
the process to work and doing some poking around on this board, my
understanding is now that the Lookup only supports returning a single
row of data. Is this correct? If so, are there any recommendations on
alternate ways I can accomplish my need?

I am using SQL 2000.

Thanks in advance for any help. Sorry if my explanation is not clear.

Rich

If you want to return multiple records, I suggest you change strategy and
instead of using a lookup, use a linked server. On your SQL Server, create a
linked server that points to your source table. Write a distributed join
query that returns data from your source data and the reference table. Use
this as the source of your DTS pump task.

Charles Kangai, MCT, MCDBA

"rsbaier (AT) gmail (DOT) com" wrote: