I am in the process of planning for moving a database to a new sql2000 instance. The problem is I found out there is several hundred DTS packages saved as structured storage files (.DTS) that will need to be editted to reflect the new instance name. The only way I know how to do this is to edit each one individually. Does anyone know of any tools or tricks to do this quickly?
I don't know of a way to change something in all the packages without opening each one, but here's a thread that describes several ways to avoid that situation: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=102397
You can load each File up with VB, Find the Object you need to change in the object model, and then save them Back. I manipulate DTS packages all the time this way...