DTS can't read from network drive? 
Author Message
 DTS can't read from network drive?

Using SQL Server 7.0; simple bulk load.  Trying to read a file from the U:
drive, which is mapped to another system.  DTS gets error 86--invalid
password, but the file can be read easily from Windows Explorer or command
prompt (running under the same username).

After seeing this, I vaguely remembered reading somewhere that maybe DTS
couldn't read files from a network drive.  This theory is bolstered by the
observation that when you're ready to give DTS the file path, and you click
the Browse button, it only shows local drives.

So is this true--that it can't read from a network drive?  Seems awfully
strange.

         -- Warren



Sun, 13 Mar 2005 00:36:29 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Error Reading Drive 'X'

2. xp_cmdshell reading a novell network drive

3. Reading network drive with Reportsmith

4. How to read files which locate network drive ?

5. Error reading Network Drive

6. Indexing a network read only drive

7. Infamous: Network error reading drive..

8. Network drive connection in DTS

9. DTS mappd network drive problem

10. mapped network drive file can't import

11. Can't Update Table if Database is not a Networked Drive

12. PDOXWIN 4.5 won't release network drive after file access


 
Powered by phpBB® Forum Software