DTS/ SQL Agent question

We're having to install new SQL servers on a new naming convention. We
know the changes we have to make on the applications that hit the SQL boxes.
However, we are not sure what DTS or SQL Agent jobs would need to be
changed.
Is there a way that we can search the DTS & SQL Agent jobs for a literal
that would refer to our old SQL server name and could identify & change
it to run on the new one?
Or,
is there a way to pass a parameter into the DTS or the Agent jobs that
would point them to the new server?
We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003
and SQL 2000.
Any ideas appreciated.
Thanks,
BCFor the agent jobs, you can script them out and search through the SQL that
is created. For DTS, you could probably save it as a VB file and search
through that.
Hope this helps!
--
Chuck Heinzelman
MCSD, MCDBA
I support the Professional Association for SQL Server (www.sqlpass.org)
This posting is not an endoresment of any product.
Information is provided as-is, and carries no warranties - either express or
implied.
Please respond in newsgroups only.
"Blasting Cap" <goober@.christian.net> wrote in message
news:OtNNUaXaGHA.4780@.TK2MSFTNGP02.phx.gbl...
> We're having to install new SQL servers on a new naming convention. We
> know the changes we have to make on the applications that hit the SQL
> boxes.
> However, we are not sure what DTS or SQL Agent jobs would need to be
> changed.
> Is there a way that we can search the DTS & SQL Agent jobs for a literal
> that would refer to our old SQL server name and could identify & change it
> to run on the new one?
> Or,
> is there a way to pass a parameter into the DTS or the Agent jobs that
> would point them to the new server?
> We're running Windows 2000, SQL 2000. We'll be moving to Windows 2003 and
> SQL 2000.
> Any ideas appreciated.
> Thanks,
> BC