Post reply

SSIS error: "Could not find a part of the path"

  • February 23, 2007 at 4:04 am

    #171529

    Hi, In my SSIS script task Im doing this:

    If File.Exists(strOriginalfile) = True then......

     where 'strOriginalfile' points to a file on a network drive. Now, when I run the SSIS package from visual studio the code works just fine. But when I run the package as a job under sqlserver agent I get this error: "Could not find a part of the path 'Z:\FredrikTest\fsgrptmaxiiar.txt'.".

    Does'nt sqlserver agent have permissions to access the network drive? When I run the package from visual studio I can see that its my account who is running the package. When run under sqlserver agent, its the NT AUTHORITY\SYSTEM. Strange if this account should'nt have permissions....

    some help, please..

    Fredrik   

  • February 23, 2007 at 4:07 am

    #691352

    Fredrik

    NT AUTHORITY\SYSTEM only has access to the local computer.  You should start the SQL Server Agent service with a domain account that has permissions on the share you want to access.

    John

  • May 9, 2007 at 5:56 am

    #705177

    There may be an other reason for this error!

    Try to change the path from Z:\ to \\servername\shared_directory

    Permission is needed as well.

    Franz

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

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