Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ells
Starting Member
25 Posts |
 Posted - 2008-03-06 : 05:51:41
|
| Scenario:Multiple DTS packages execute SQL tasks against a SQL Server instance on another domain. As the SQL instance can not be addressed by name (just dont ask, no really dont ask) the server is referenced via the ip address. So the SQL task will contain select *From [10.444.555.666].Cat.owner.tablenameWhere .....In addition there are also Connections in packages that refer to the server by IP address. The IP address is going to change, which I think will mean I loose any information in the connection task. I am guessing I can just recode the ip address in the sql tasks.1. Is it all going to go really wrong?2. Whats the damage likely to be?3. Any recommended strategy? Any one been through this before?One thing I am interested in is backing up to file all the packages. I guess then I would be able to search the files for reference to the ip address and change the ip. Any other thoughts greatly appreciated.Many Thanks.Mark. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-06 : 13:47:16
|
| Next time you should just add an alias so you can use the server name even if the network doesn't resolve it. Aliases allow you to point a name to either a server name or IP address. So you could have created an alias named Server1 that pointed to 10.444.555.666 and then all of your code could have used Server1.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
ells
Starting Member
25 Posts |
Posted - 2008-03-07 : 02:56:57
|
| Unfortunatelly I have inherited this mess and am desperate to try and get out of this mess.I would never had put the IP address in there in the first place. I just have this mess and need1. A way to back up the DTS (I know DTSBackup2000 will, but if the connection has changed whats the value of the dts with an incorrect connection)2. Would a disconnected edit alllow me to edit a connection and see the previous values?My plan initially was 1.backup all DTS packages. (Ideally in a state where I could edit them)2. Go through each package and change the IP address to the new name. The name has been created and when the IP changes it should be seamless.3. Do it yesterday so I get a bit of live testing prior to the switch.Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-07 : 11:56:37
|
| Yes you will be able to make modifications to the DTS package once the change has been made via disconnected edit. I backup packages by saving them as structured storage files and then adding them to our source control.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
IP address change