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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How can I dynamically change unc names

Author  Topic 

sand-lakes1
Starting Member

29 Posts

Posted - 2001-12-03 : 10:27:23
I am using unc names on our live sql server 7.0. The unc names used within packages, jobsteps should be changed. Is there a way to do it dynamically or should this be done step by step ?

thanks in advance

John

dsetzer
Starting Member

31 Posts

Posted - 2001-12-03 : 10:48:07
You could store the UNC paths in a database table and just update that with a simple update statement.

-doug

Go to Top of Page

sand-lakes1
Starting Member

29 Posts

Posted - 2001-12-04 : 04:23:33
quote:

You could store the UNC paths in a database table and just update that with a simple update statement.

-doug



Thanks for the answer Doug, but I don't understand how to use unc names added to a table concerning separate packages and unc's used within separate job steps. Please explain.



Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-04 : 04:52:42
Please don't cross post this in multiple forums. Everyone reads all the forums. I am going to kill the other threads now.

Damian
Go to Top of Page
   

- Advertisement -