Post reply

Connecting to flat file through SQL server Agent

  • January 20, 2009 at 4:08 pm

    #125782

    I have flat file on a mapped network drive that I load into a DB table. When I run the SSIS pack from visual studio, it works fine. But when I try to run the pack from SQL server agent , I get an error that says cannot open file. Why would the connection work from visual studio but not through SQL server agent? Does it have anything to do with the ProtectionLevel propery?

  • January 20, 2009 at 7:53 pm

    #930039

    What kind of authentication are you using to connect to the file? Sounds like user running job does not have access to file.

  • January 21, 2009 at 8:48 am

    #930420

    Switching to a UNC path fixed the problem.

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

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