DTS Failing

[namtab]

If I try import a file located on a network drive isH:\xxxx.txt, DTS fails that it cannot find the path specified. How ever if I have the full path name ie <server>\<directory>\xxxx.txt it works?????
is there something im missing here

 

[gradley]

I don't remember the technical reason for it but, SQL Server does not recognize mapped drives (Ex: H:\). You have to use the server path if it's a network file. The same holds true when backing up a database to a network drive.

 

[pkailas]

The reason you can't use Mapped drives is that SQLSERVERAGENT needs to be logged on as a user with those mappings. Always use a UNC path.

 

[namtab]

Pkailas,

If the SQLSEVERAGENT is using the same log as my account shouldn't it still work? I tried doing a bulk insert in query analyser and using the mapped drive is still doen't recogonise it. It seems strange I thought there would be more maintenance using UNC.

 

[EdwinGene]

I had to use mapped drive letters for exporting to and importing from text files into and out of SQL Server because of the client's security concerns, so I know it can be done. However, the drive letter must be a mapped drive letter on the SQL Server box, and the SQL Server network user must have permissions on the physical path the mapped drive points to.