I'm using DDQ for my DTS package. I have already set 3
connections which point to different database. 2 are
source and the other 1 is the destination. How can I
select the source from 2 different database and put them
into 1 destination database??? Thanks........

Why are you using a DDQ?

For me the DDQ is for those occasions when I can look at the source data and
identify whether when i get to the destination I should be issuing an
UPDATE , INSERT or DELETE. If this is not true for your situation then use
a DataPump.

Combining two sources into 1 destination can be done best IMHO by one of the
following two methods

1. Linked servers. Create a linked server for Source2 from Source1. Your
Source connection for the DataPump is then Source1
2. Pump the rows you need on Source2 to a working table on Source1. You
can then use Source1 as the source for your datapump and a TSQL Statement.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Chin" <anonymous (AT) discussions (DOT) microsoft.com> wrote