sql server dts: Help: Using DDQ to update another DB's table -- sql server dts

Help: Using DDQ to update another DB's table

memiller NO[at]SPAM westernsurety.com
3/29/2006 1:21:59 PM

sql server dts:

I'm using MS SQL 2K. I'm trying to design a DTS that uses DDQ that
uses a query as its source from DB1, then using that data it needs to
update a table in a second DB (DB2). Both DBs are defined in the DTS
as a Connection. I have the source query completed and tested, I've
defined my binding table and mapped the transformations. On the
Queries tab, I select Update for the Query Type, then defined an update
query using the ? param. What I don't understand is when I click on
the button to Show/Parse Parameters, it only lists the field names of
my destination table. As if I am trying to update the target table
with target data. What am I doing wrong?

Here is the query I have on the Queries tab:

UPDATE DB2.Table
SET PersonId = ?
WHERE CustID= ?

RE: Help: Using DDQ to update another DB's table

Enric
3/30/2006 1:56:03 AM

What does 'DDQ' mean?
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)

[quoted text, click to view]

Re: Help: Using DDQ to update another DB's table

memiller NO[at]SPAM westernsurety.com
3/30/2006 6:39:48 AM

DDQ = Data Driven Query

Other than the update query and my source query, there isn't anything
else I can post, unless I attach screen shots (can that be done?). The
rest of the setup is graphical.

Re: Help: Using DDQ to update another DB's table

memiller NO[at]SPAM westernsurety.com
3/30/2006 8:16:04 AM

Ok, I figured out my problem. I guess I need to define my
transformation mappings in ActiveX. I was doing this graphically.
Thanks for showing interest!

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.