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/
    dineshasanka, Jul 25, 2007
    #2

  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.
    satya, Jul 25, 2007
    #2

  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...
    yorkw, Jul 26, 2007
    #2

  4. dineshasanka Moderator

    Did it.
    Ran following command, just before the dtsx execution
    net use M: \19.1.1.36e$ pwd /user:user
    dineshasanka, Jul 28, 2007
    #3

Share This Page