all groups > sql server dts > june 2006 >
You're in the

sql server dts

group:

Data Driven Query Task - More than one UPDATE


Data Driven Query Task - More than one UPDATE brenda.bender NO[at]SPAM gmail.com
6/29/2006 7:02:08 AM
sql server dts: 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.-
RE: Data Driven Query Task - More than one UPDATE Matt
6/29/2006 7:59:02 PM
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.

[quoted text, click to view]
Re: Data Driven Query Task - More than one UPDATE Brenda
7/24/2006 8:38:31 AM
Thank you very much... I will give it a try!!!

[quoted text, click to view]
AddThis Social Bookmark Button