Accsssing a M,ap Drive | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Accsssing a M,ap Drive

This is bit strage.
I have a SSIS access a map drive. I have given the permission to agetn service account to the map drive. When I logged from service account and run the SSI sit works fine. But when it runs from the job it is not running. What may be the issue. I am sure it is something to do with permission —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
What is the error when executed as job? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Are you logging on to your workstation with the service account or actually logging on to the server itself?? When SQL Agent runs the job, the mapping is relative to what the server itself has mapped….if it runs OK from your workstation but not from SQL Agent, the server may not have the same mapping as your workstation…
Did it.
Ran following command, just before the dtsx execution
net use M: \19.1.1.36e$ pwd /user:user
]]>