Data Driven Query Task - More than one UPDATE

#1

Hi all

I have several data driven query tasks in the DTS I am working on.
I have only one type of query but which has to UPDATE more than one
table and I am not finding the way to do it nor I have found
information in the web.
How do I update more than one table in the same query?
Thanks in advance.

Brenda.-

#2

You could create a lookup query that actually updates a table. Just call the
lookup from your ActiveX script and pass in the appropriate values that you
need to perform the update.

"brenda.bender (AT) gmail (DOT) com" wrote:

Quote:

Hi all

I have several data driven query tasks in the DTS I am working on.
I have only one type of query but which has to UPDATE more than one
table and I am not finding the way to do it nor I have found
information in the web.
How do I update more than one table in the same query?
Thanks in advance.

Brenda.-

#3

Thank you very much... I will give it a try!!!

Matt wrote:

Quote:

You could create a lookup query that actually updates a table. Just call the
lookup from your ActiveX script and pass in the appropriate values that you
need to perform the update.

"brenda.bender (AT) gmail (DOT) com" wrote:

Hi all

I have several data driven query tasks in the DTS I am working on.
I have only one type of query but which has to UPDATE more than one
table and I am not finding the way to do it nor I have found
information in the web.
How do I update more than one table in the same query?
Thanks in advance.

Brenda.-

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

Data Driven Query Task - More than one UPDATE

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

Data Driven Query Task - More than one UPDATE - 06-29-2006 , 09:02 AM

RE: Data Driven Query Task - More than one UPDATE - 06-29-2006 , 09:59 PM

Re: Data Driven Query Task - More than one UPDATE - 07-24-2006 , 10:38 AM