Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Editting DTS packages Expand / Collapse
Author
Message
Posted Friday, June 24, 2005 12:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 7, 2006 1:24 PM
Points: 5, Visits: 1

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
Post #194036
Posted Monday, June 27, 2005 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #194322
Posted Thursday, June 30, 2005 6:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2008 4:19 PM
Points: 110, Visits: 17
The only thing I would suggest is to save the DTS packages to VBscript and do your editing that way.

HTH
Marty
Post #195655
Posted Friday, August 19, 2005 9:21 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 4,065, Visits: 5,284

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
Post #212142
Posted Monday, January 23, 2006 10:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 20, 2008 11:53 AM
Points: 1, Visits: 2

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

Post #252868
Posted Friday, February 10, 2006 4:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 23, 2009 9:10 AM
Points: 67, Visits: 6
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.
Post #257709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse