Performing lookups with recordset variables

#1

Is it possible in SSIS to perform a lookup with a recordset variable? I
looked at the lookup component, but it only wants a database table to perform
a lookup with and my data is in a flat file (that I don't want to have to
stick in a permanent table).

Can this only be done using a script component? If so, what are the basic
steps?

Thanks!

Brandon

#2

Hello Brandon,

You cannot do it with anything obvious AFAIK. The Lookup Transform itself
expects an OLE DB connection manager for the reference table.

What about using a Merge Join Transform Instead?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Is it possible in SSIS to perform a lookup with a recordset variable?
I looked at the lookup component, but it only wants a database table
to perform a lookup with and my data is in a flat file (that I don't
want to have to stick in a permanent table).

Can this only be done using a script component? If so, what are the
basic steps?

Thanks!

Brandon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Performing lookups with recordset variables

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Performing lookups with recordset variables - 04-12-2006 , 06:04 PM

Re: Performing lookups with recordset variables - 04-12-2006 , 07:37 PM