Post reply

Cant Acquire Connection from SQL Agent

  • October 31, 2008 at 12:00 pm

    #154870

    I have a package that

    1st deletes data in database using SQL , this works always

    2nd reads Excel file from network drive, this only works when I execute it. If its run as a job under Agent using a proxy it fails on the connection everytime.

    Our network folks setup the proxy account and have verifed it has access to the directory and file.

    What could I not being correctly

    Any help appreciated.

    Richard

  • November 1, 2008 at 7:34 am

    #892712

    Can you post as much information from the error as possible?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • November 1, 2008 at 8:32 am

    #892725

    Thanks,

    It turns out the network folks thought they had permissions set but really didn't

    Its working now

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

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