SQL Server Performance

Accsssing a M,ap Drive

Discussion in 'SQL Server 2005 Integration Services' started by dineshasanka, Jul 25, 2007.

  1. dineshasanka Moderator

    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/
  2. satya Moderator

    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.
  3. yorkw New Member

    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...
  4. dineshasanka Moderator

    Did it.
    Ran following command, just before the dtsx execution
    net use M: \19.1.1.36e$ pwd /user:user

Share This Page