Post reply

Using UNC path for a Flat File Destination pointing to Network Share raises error.

  • December 15, 2008 at 10:43 am

    #132986

    Hi,

    I'm using a Flat File Destination which points to a network file share. I've tried using the UNC path but it always errors when I run the package from a SQL Agent Job saying "Description: The file name "\\SERVERNAME\SHARE\FILE.txt" specified in the connection was not valid.", but it runs fine from SSIS. Would this be affected by package level protection as well? Any help is much appreciated.

    Thanks in advance!

  • December 15, 2008 at 11:40 am

    #912687

    The SQL Job Agent account you use to run the package, most probably doesn't have permissions to this share. Do you use the SQL Job Agent account or you have setup a proxy account? Check here about running SSIS packages with SQL Job Agent.

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

  • December 15, 2008 at 2:14 pm

    #912794

    Thanks Cozyroc! Great link. Creating a proxy solved my issue.

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

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