June 20, 2017 at 7:23 am
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
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
Is G: a local or network drive?
Does the SQL Agent user have rights to the folder?
June 20, 2017 at 7:45 am
John Mitchell-245523 - Tuesday, June 20, 2017 7:31 AMIs 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
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
John Mitchell-245523 - Tuesday, June 20, 2017 7:52 AMIn 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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy