"Is not in path" error?

  • Brad Allison

    Hall of Fame

    Points: 3473

    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

  • John Mitchell-245523

    SSC Guru

    Points: 148315

    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

  • Phil Parkin

    SSC Guru

    Points: 243688

    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.

  • Brad Allison

    Hall of Fame

    Points: 3473

    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

  • John Mitchell-245523

    SSC Guru

    Points: 148315

    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

  • Brad Allison

    Hall of Fame

    Points: 3473

    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