Temp storage space for DTS output text files -
09-26-2006
, 02:05 AM
A ple for advice...
The DBA's have configured the SQL Server 2000 (running on Windows Server
2003) DTS to run under the SA SQL Account and not a Windows account -
apparently this is the best way to do things.
We have written a DTS job that extracts data once a week, writes it to a
disk file and then FTP's that disk file to a Unix server for processing, and
everything works great.
Now we are told that we cannot store the file locally on the server in case
it consumes too much disk space.
I always assumed that because DTS is running under the SQL SA account it has
no permissions on the Domain to access remote servers so we can't write the
file to, for example \\Server1\FolderX\...
Is this correct ? |