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