June 24, 2005 at 12:45 pm
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?
WCDBA
June 27, 2005 at 8:00 am
This was removed by the editor as SPAM
June 30, 2005 at 6:00 am
The only thing I would suggest is to save the DTS packages to VBscript and do your editing that way.
HTH
Marty
August 19, 2005 at 9:21 am
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
Greg
Greg
January 23, 2006 at 10:14 am
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...
February 10, 2006 at 4:47 pm
You'll probably have to loop through the files, and for each one, call a function to fix it.
In the function, you probably have to create an object of type DTS.Package, and call its LoadPackage routine, giving it the filename. Then you have the DTS.Package object read to be edited, and then, I think the package object has a connections property, so probably you loop through all the connections, adjusting some property on each.
As you can guess from how fuzzy I am on the details here, I've not done this.
I think you could do the whole thing in VBA or VBS or VB, probably.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply