Change Lookup Query

#1

Is there a way to programatically change the query that Lookup is executing?
I gave up trying to find a way to reset a connection each time the lookup is
called.

Thom

#2

Hello Thom,

You can get to the query property of a lookup using something like this

dim lkp

for each lkp in DTSGlobalVariables.Parent.Tasks("DTSTask_DTSDataPu mpTask_1").CustomTask.Lookups

MsgBox lkp.Query

Next

Allan

Quote:

Is there a way to programatically change the query that Lookup is
executing?
I gave up trying to find a way to reset a connection each time the
lookup is
called.
Thom

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

Change Lookup Query

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

Change Lookup Query - 06-05-2006 , 11:42 AM

Re: Change Lookup Query - 06-05-2006 , 12:14 PM