We are moving a SQL 2000 Server to a SQL 2005 Server. The Server will be completely new so I need to go through a lot of DTS packages to find any reference to the current server name so the processes can be changed to the new server name.
I have seen one or two entries on here about using VB to export all the packages into VB. I need to be able to only pull the packages that specifically reference that server name. Does anybody have any ideas?
I can write some VB but am not a VB Programmer. I need to do this fairly quickly. I did find code on here that will allow mass export into VB but I wondered if there is a way to search within the packages using VB so I am only getting the packages I need.