DTS package transfer

Question

Hi,

I have a problem transferring DTS packages from one server to another.
I have almost 400 DTS packages in server 1X0001 and want to transfer them to server 2X0002 along with the databases corresponding to the DTS packages. The problem is it's hard to change all the connection in the DTS packages from 1X0001 to 2X0002 manually.
So is there any other way to change the connection properties for all the DTS packages at once?
Thank you in advance.

Answer 1

I would recommend changing the connection strings manually without needing to depend on any other 3rd party tool.
Though it sucks all your time , i think it is better and much reliable.
Also i am not aware of any such intelligent tools to connect to DTS and change only the connection strings.

---

Thanks, Leks

Answer 2

there must be some tool, else I would be doing it for long time!!!!!

Answer 3

Request you to check the article
http://www.dbazine.com/sql/sql-articles/larsen8

---

Vidhya Sagar. Mark as Answer if it helps!

Answer 4

Hi Vidhya ,

Nice article . thanks for that.

Hi SQL sathi,

Can you let us know how is it to migrate dts packages by this procedure , if you are trying this way ?

---

Thanks, Leks

Answer 5

thanks Sagar,

I went through the article and I found it confusing. I'm relatively new to SQL Server 2000 and I don't know where to use the VB Script. If you have done it or understand the article can you please explain me little bit. Your input is highle appreciated.
Thank you.

Answer 6

Hi,

For using VB Script in SQLServer 2000, you may try the following article which shares a step by step tutorial on how to start.

http://msdn.microsoft.com/en-us/magazine/cc301942.aspx

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.