"Leo Demarce" <LeoDemarce@discussions.microsoft.com> wrote in message
news:67E02DEF-C419-4473-8C0F-F3924740B8B7@microsoft.com:

> I want to use DTS to update a table from a view of another database. I have
> 3 databases in total, 3 are subs and 1 is a parent. The parent will have a
> table that is to be updated by the 3 subs. I have created a view in each of
> the 3 subs that are identical, but have a unique key. The parent database
> has a table that I want to populate with data from the 3 views.
>
> I know how to set up a DTS that will empty the table, then populate the data
> from each of the 3 subs by appending the data.
>
> Is there a way to append the data without having to empty the table with the
> new data from each of the subs?