[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 561
  • Last Modified:

Export multiple DTS packages based on processes in the packages

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.

Please help.
0
mwrye
Asked:
mwrye
1 Solution
 
James MurrellProduct SpecialistCommented:
i have used this method

http://www.sqldts.com/204.aspx
0
 
mwryeAuthor Commented:
Thank you for your reply on this.  I actually wound up just using a VB script and pulling them that way but thank you for taking the time to reply.  I do like the DTS site - good info found there.
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now