Post reply

Invalid file name in connection

  • March 14, 2008 at 3:03 pm

    #379235

    I have a SSIS package that is writing a file on a remote server. I'm able to run it myself with out errors, but when the package is moved to a different SQL server, I'm getting the follow error trying to access to file:

    Code: 0xC001401E

    Source: xxxxxxxx

    Description : The file name "\\servername\dir\file.txt" specified in the connection was not valid.

    END Error.

    Any help would be appreciated.

  • March 14, 2008 at 6:21 pm

    #789936

    Is the directory a SHARED one? Can you access the other server and path from the server where you are running the package from? It sounds like a permissions issue.

    If it is shared, you need to remember to put the shared symbol.

    \\servername\D$\

    -SQLBill

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

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