|
Home > Archive > MS SQL Server DTS > March 2006 > Help: Using DDQ to update another DB's table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help: Using DDQ to update another DB's table
|
|
| memiller@westernsurety.com 2006-03-29, 8:27 pm |
| 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= ?
| |
|
| 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)
" memiller@westernsure
ty.com" wrote:
> 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= ?
>
>
| |
| memiller@westernsurety.com 2006-03-30, 9:31 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.
| |
| memiller@westernsurety.com 2006-03-30, 11:28 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!
|
|
|
|
|