Post reply

"Is not in path" error?

  • June 20, 2017 at 7:23 am

    #338255

    I am not sure exactly what this error is.  We had a hard drive crash not too long ago and I lost a few SSIS jobs.  One of the jobs points to an exe file that needs to run first and it points to the G: drive.  I have also tried typing the UNC path directly, but still get the same.  Is there something else to this error that I might be missing?

    Thanks

  • June 20, 2017 at 7:31 am

    #1947372

    Is the batch file in the root of the G drive?  Please try moving it to a subfolder - I've seen strange things happen when trying to programatically access files in the the root of a drive.

    John

  • June 20, 2017 at 7:34 am

    #1947374

    Is G: a local or network drive? 
    Does the SQL Agent user have rights to the folder?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

  • June 20, 2017 at 7:45 am

    #1947375

    John Mitchell-245523 - Tuesday, June 20, 2017 7:31 AM

    Is the batch file in the root of the G drive?  Please try moving it to a subfolder - I've seen strange things happen when trying to programatically access files in the the root of a drive.

    John

    Nope, not in the root, it is in a subdirectory. Also this dtsx file is not published to SQL server.  It is run from a batch file using the DTEXEC utility.  I changed all instances of "G:" in the XML code to read the direct UNC of \\sql12_01\swmbh\...  This is a share directory on that server.  But now I get this error

  • June 20, 2017 at 7:52 am

    #1947378

    In the first error, you're missing a backslash from your path.  What it's looking for is a file called "sftpto Televox.bat".  Do you have Integration Services installed on the server?  I think that second error may be telling you that you don't.

    John

  • June 20, 2017 at 8:11 am

    #1947383

    John Mitchell-245523 - Tuesday, June 20, 2017 7:52 AM

    In the first error, you're missing a backslash from your path.  What it's looking for is a file called "sftpto Televox.bat".  Do you have Integration Services installed on the server?  I think that second error may be telling you that you don't.

    John

    I am sure that is the issue (not having IS installed).  I will get in contact with our network admin who has been rebuilding this server and make sure it is.  Thanks for the information

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

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