Re: Using DTS to update a cental SQL server from MSDE

Tech-Archive recommends: Fix windows errors by optimizing your registry

You could certainly do this yes using DTS yes but it smacks more of being something for which I would use replication.

--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com




"Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:716AE5B7-9352-4607-AD64-A71FF3324C1A@xxxxxxxxxxxxx:

I have machines in a network with MSDE on them. The databases on these
machines use the same schema. I would like to setup a central SQL server to
poll these DBs and copy selected data and adding the machine name in a field
to identify the data, so I can query the individual machines data and cross
reference, etc. I would like to know if this would be possible using DTS?

Also could there be an LDAP lookup or other to an Active Directory OU to
pull the machine names that I wish to copy the DBs from.

If all this can be done, how difficult would it be not knowing DTS but with
good SQL and scripting skills.

Thanks in advance

.

Relevant Pages

  • DTS + ASP.NET
    ... I load the DTS package using windows authentication. ... application and the database server is on two different machines and the ... domain controller is on the web server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Multiple Computers, First takes mail, second cant get it.
    ... copy of messages on the server. ... Do this on all machines, but be sure to set one machine to delete messages, ... MS-MVP. ... [DTS] ...
    (microsoft.public.windows.vista.mail)