July 23, 2004 at 7:40 pm
Hi all,
Was wondering if anyone could help me out with an issue with DTS packages when trying to run them from a client tools install on a workstation.
We're running SQL Server 2000 (SP3) with mixed mode logins and have installs of the client tools on multiple workstations. The problem is that the DTS files are stored on E:\MSSQL\Scripts on the server, but whenever a DTS package is executed from one of the workstations the script fails to run as it tries to write tempory files to the E:\MSSQL\Scripts directory but the workstations don't have an E drive.
Was wondering if there is anyway that I can change where the temporary files are written to on the workstations from E:\MSSQL\Scripts to a directory on C drive?
Regards,
James
July 25, 2004 at 6:32 pm
You can do this....
Create a directory on the C: drive. Map that directory as E:. Create the MSSQL and the Scripts directories underneath that directory.
It's the quickest approach. A better option is to re-develop the DTS package so it doesn't use the E: drive at all but rather say %TEMP% or %TMP% as the temporary path. That'll ensure it'll have a location to write temporary files no matter what the system configuration.
K. Brian Kelley
@kbriankelley
July 27, 2004 at 6:59 am
Thanks, very much!
I had thought about mapping a directory approach but it seems a little too clunky. It's also a problem if a workstation is using E as a CDROM drive.
I will definely try using the %TEMP% option.
Thanks for your help.
Regards,
James
July 27, 2004 at 8:39 am
You can through disk administration move what drive letter the CD-ROM sits on. Of course, this might affect other processes, but it is always a possibility.
Start | Run | Compmgmt.msc
Disk Management
Right Click on the CD-ROM drive
Choose Change Drive Letter and Path...
HTH.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply