Post reply

CSV import fail when set as sql job

  • January 26, 2011 at 2:14 am

    #144818

    Hi

    I have a csv file on a fileserver.

    I need to import this into a table in one of our sql 2005 servers.

    I have tried both the import wizard and to create the ssis my self.

    Running manually both works just fine. But when I create a standard job it fails.

    To me it looks like this might be a user security problem, but I am not able to figure it out.

    Aany ideas?

    Best regards

    Dan

  • January 26, 2011 at 2:18 am

    #1278344

    does the account that the sql agent run under have access to the file server and file?

  • January 26, 2011 at 2:21 am

    #1278347

    Hi Steve

    Yes the user for sql agent is the same as my login user to both the sql server and the file server.

    Dan

  • January 26, 2011 at 3:19 am

    #1278362

    Have a look at the agent history and it will have an error message in there,

  • January 26, 2011 at 5:10 am

    #1278408

    Dan-Ketil Jakobsen (1/26/2011)

    Hi Steve

    Yes the user for sql agent is the same as my login user to both the sql server and the file server.

    Dan

    Did you use a proxy account?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • January 26, 2011 at 5:29 am

    #1278415

    No proxy

  • January 26, 2011 at 6:36 am

    #1278436

    Please post the text of the error message from the job history.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 7 posts - 1 through 6 (of 6 total)

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