Post reply

Win2008 'Network Service' as SqlAgent LogOn account - Problem connecting remote drives

  • September 20, 2011 at 3:42 am

    #245088

    Hi,

    I have a problem when running a SSIS package as SqlAgent JOB. As the first step, a CMD-file is called (process task) to map a remote folder and Move CSV files to the local SSIS server folder.

    It works fine when run with SSIS but does not work when run as a job.

    'Network service' have all necessary Local Policies set, I think: Act as part of the op sys, log on as a batch job, log on as a service, and many more... I tried icluding it in Administrators but no help there either...

    Any ideas?

    V

  • September 20, 2011 at 4:13 am

    #1383697

    Hi,

    problem solved. I added 'Net use ..../DELETE' as the firs command before the actual 'Net Use....'. Maybe at some point it was stuck even though the last command in the batch is also 'Net use ..../DELETE'

    V

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply