sql server dts: Retrieve multiple records from DTS Lookup -- sql server dts

Retrieve multiple records from DTS Lookup

rsbaier NO[at]SPAM gmail.com
8/23/2006 3:09:57 PM

sql server dts:

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

RE: Retrieve multiple records from DTS Lookup

Charles Kangai
8/24/2006 7:29:02 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.