As an update, this is working now once I included the full path to the executable. Odd that the batch file works from a command prompt on the server without the full path when running manually, but not when called from the GoAnywhere job. At least it is resolved and the job works perfectly now. Full...

Today I installed the Microsoft Command Line Utilities 11 for SQL Server on our GoAnywhere server. I need to be able to run sqlcmd and bcp commands in batch files to grab data from SQL Server databases. The batch file is written and if I execute it manually on the server, everything works as it shou...

I'm running into a problem which I think may be some sort of permissions issue with a scheduled job. I can run the project manually with no errors. The project reads an Excel file from the server, writes it to a database table, queries the data, and writes it back to a .CSV file. It is setup as a sc...

Thanks so much for the info. I'll give that a shot. I had read in some other forum somewhere online that I could query directly from a rowset variable, so that's what I was trying. This makes more sense and should work great for what I need.

Thanks again!

Upfront disclaimer: I'm very new to GoAnywhere Director. I have a problem where I need to read data from 2 columns (column 1 and column 4) of an .XLS file, sort it, and write it back to a .CSV file. I've created the project below, but I'm getting an error that the resource is not found. I used the r...