Getting Files From Mapped Drive

[macrane]

I have a DTS package that runs on my SQL Server that is supposed to get csv formatted files from a mapped network drive (R. The files are there every morning, but the job is bombing as if the files are not there. I understand that the SQL Server Agent does not use the same drive mapping as is on the server itself. Is there a way to tell the SQL Server Agent or the scheduled DTS package to look at the R drive?

Any help is greatly appreciated!

 

[JohnDTampaBay]

Use a universal naming convention (UNC) filename like \\Server\Directory\SubDirectory\SubSubDir\Filename.Extension

I hope this helps. Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.