Migrating DTS to several locations

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: SQLCluster (SQLCluster_at_discussions.microsoft.com)
Date: 02/05/05 

Date: Sat, 5 Feb 2005 07:59:02 -0800

I have over 182 DTS packages that reside on 54 SQL servers each is a diffrent
server, the DTS packages pull data from SQL server databases, sybase &
oracle. The plan is to move the databases to 4 SQL servers, is there an easy
why to find which DTS package uses which databases so we would now what to
migrate a long with the databases. Thanx

Relevant Pages

  • Restricting Access to BUILTINAdministrators
    ... I have a bunch of SQL servers that I inherited when I took over ... Grant that the System Administrator role to the NT Group and ... both accounts then you are denied access (Deny supercedes Grant). ... Looking at one of the databases my domain user is the owner and there is no ...
    (microsoft.public.sqlserver.security)
  • Re: Planning to move SQL 7.0 to 2000 on to a new server
    ... http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases ... Issues When a Database Is Moved Between SQL Servers ... What databases to I> need to do this other than user databases? ...
    (microsoft.public.sqlserver.security)
  • Re: Migration Question Again...
    ... You have to migrate the system databases too, specifically Master and MSDB ... As soon as you restore the Master and MSDB all your ... all DTS packages wil be in MSDB database. ...
    (microsoft.public.sqlserver.setup)
  • Help on code in a SP
    ... I'm currently auditing some SQL servers to have an overview on what's ... running/existing in the different databases. ... I found User's Stored Procedures in MSDB databases ...
    (microsoft.public.sqlserver.server)
  • Re: Large DB vs Several Small DBs?
    ... I manage dbs in 2 enviroments. ... 100 - SQL Servers ... We are in the process of adding the ability of each customer having ... multiple databases. ...
    (microsoft.public.sqlserver.server)