sql server dts: Newbie needs to create DTS using 3 DBs -- sql server dts

Newbie needs to create DTS using 3 DBs

mcourter NO[at]SPAM mindspring.com
9/13/2005 5:49:53 AM

sql server dts: i need to create a DTS that operates as follows:
Table A resides on server I, DB X, and receives the new rows and
updates based on values found in Table B.
Table B resides on server II, DB Y, and contains a key value used to
extract valid records from Table C.
Table C is found on server III, BD Z, and contains the the required
columns for table A. None of the column names in Table A match Table C
and some values for Table A are values that are joined to table C.

I can manage the joins in Table C.

What i need is an outline of how to put all of this together.

Thanks in advance for your help.

mcnewsxp

Re: Newbie needs to create DTS using 3 DBs

Allan Mitchell
9/13/2005 7:18:26 PM

Have you thought about using Linked Server?

Allan

[quoted text, click to view]

Re: Newbie needs to create DTS using 3 DBs

mcourter NO[at]SPAM mindspring.com
9/14/2005 4:15:25 AM

i have, but not sure if it's an option.
if so, what would the DTS look like?

Re: Newbie needs to create DTS using 3 DBs

mcourter NO[at]SPAM mindspring.com
9/14/2005 7:58:33 AM

i can't use linked server.
this has to be done with DTS.

Re: Newbie needs to create DTS using 3 DBs

Allan Mitchell
9/14/2005 6:40:06 PM

Ok so you cannot use linked servers. The easiest way is to send the
data from the remote servers to one of the other servers so the data is
all in one place. Once it is all in one place you can simply use TSQL.
I would have staging tables on the destination server/DB that holds this
transient data. I would also ensure you only move data that needs
moving.

Allan

[quoted text, click to view]

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.