 | |
Re: Hot to get the DTS Script
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: Hot to get the DTS Script -
10-07-2003
, 12:19 PM
|
Hi. I have a DTS to import information from one server to another, and it works fine, but I need to put the same DTS on 10 diferents servers. The servers IP's change, then i need to change it on the DTS one by one server. My question is, there's a way to get the script of one DTS an edit the script? I try the option save as.. file.. but it doesn't works, all I get with this option is a codified script that i can't edit. I need to do something else before save as.. the DTS? It's possible to get the script and edit it? thanks for your time. |
#2
| |||
| |||
|
|
-----Original Message----- You could 1. Save As VB 2. Use Client Config Utility to alias the servers in the DTS package. This way when you move them then they simply need to created in Client Config Utility on the other box. No messing with the package 3. Parameterise the names of the server using Global Variables and use a Dynamic Properties task to change them at runtime. Connections (http://www.sqldts.com/default.aspx?101) -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Daniel Alvarado" <alvaro_dag (AT) hotmail (DOT) com> wrote in message news:011701c38cf4$bd504890$a401280a (AT) phx (DOT) gbl... Hi. I have a DTS to import information from one server to another, and it works fine, but I need to put the same DTS on 10 diferents servers. The servers IP's change, then i need to change it on the DTS one by one server. My question is, there's a way to get the script of one DTS an edit the script? I try the option save as.. file.. but it doesn't works, all I get with this option is a codified script that i can't edit. I need to do something else before save as.. the DTS? It's possible to get the script and edit it? thanks for your time. . |
#3
| |||
| |||
|
|
Thanks for your answer, but, I saw that I forgot to tell that the SQL Server versin is 7. Also I forgot to explain that it's not only the server IP what it changes, there's another little changes in every DTS, it's easier for me to edit an script, becuase I have work like this all the time. The DTS runs in a job, there's not interfase. Thanks for your time. PD: I don't understand the point 1. -----Original Message----- You could 1. Save As VB 2. Use Client Config Utility to alias the servers in the DTS package. This way when you move them then they simply need to created in Client Config Utility on the other box. No messing with the package 3. Parameterise the names of the server using Global Variables and use a Dynamic Properties task to change them at runtime. Connections (http://www.sqldts.com/default.aspx?101) -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Daniel Alvarado" <alvaro_dag (AT) hotmail (DOT) com> wrote in message news:011701c38cf4$bd504890$a401280a (AT) phx (DOT) gbl... Hi. I have a DTS to import information from one server to another, and it works fine, but I need to put the same DTS on 10 diferents servers. The servers IP's change, then i need to change it on the DTS one by one server. My question is, there's a way to get the script of one DTS an edit the script? I try the option save as.. file.. but it doesn't works, all I get with this option is a codified script that i can't edit. I need to do something else before save as.. the DTS? It's possible to get the script and edit it? thanks for your time. . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.