I need to move a DB from one server to another, and I'm trying to find all
DTS packages that connect to it so they can be appropriately updated and
moved. The box has hundreds of DTS packages (not to mention the possibility
of DTS packages connecting to it from other servers).

Can anybody offer a suggestion as to how I can find out which packages
connect to a given DB?
--
Kevin

So what I think you will need to do is

Iterate through each package on the server.
Iterate through the Connections looking at the Catalog properties

Problems are that

1. What if packages are stored using a structured Storage file?
2. What happens if they have a password applied?
3. What happens if they are on n servers/developer's workstations?



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"KevinL" <KevinL (AT) discussions (DOT) microsoft.com> wrote