I have about 800 DTS packages (saved in msdb). Each package pulls
data from an excell file. In each package's connection object the
path to the file includes a reference to a mapped drive. For some
reason this occasionally fails. I modified a few of the packages so
that they used the UNC path to the file instead of the mapped drive.
These modified packages work every time, even when the old packages
So, I want to change the path reference in all 800 packages to the UNC
name. Does anyone know how I can do a search and replace agains all
800 packages in msdb?