Editting DTS packages

  • 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

  • This was removed by the editor as SPAM

  • The only thing I would suggest is to save the DTS packages to VBscript and do your editing that way.

    HTH

    Marty

  • 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

  • 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...

  • 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