I am creating a project that needs to retrieve a single file with a name pattern similar to "file_date_time.txt". I then put the file to a specified network directory on our network, and then go back to the remote system to delete the file. When the file is put to our network, I need to change the n...

Never mind my last reply. I misunderstood what you meant. I have it working (at least compiling correctly) now using the Failed variable. .

Thanks Rick. Does this mean "Failed" is a reserved word or something? Can I pass "cmdError" back to the calling project as a variable parameter?

I am calling a generic project that will rename a file from one name to another by passing in the old and new file names as variables. I also pass a variable called Failed to designate a Pass/Fail status. However, when I try to add the On Error section of the rename to set the variable Failed to YES...

We have a similar issue writing to Excel 2007 - error about heap storage or some such thing, and running a long time. Switching back to excel 2003 runs fine and quick. Wish I could answer your post.

Thanks Duane, I've got to stop being so lazy.
Using the date manipulation tab, entering "-1" into the Day of Month value will return the previous day's day name.

Hi, I couldn't find this in the forum. I have a project that retrieves the day of the week (ex Mon, Tue, Fri) using a timestamp task. Is there a way to get yesterday's day of week name? For example, if the project runs at 01:30am on Wednesday, I want to retrieve the value of Tue. Would this be a 2 o...

Never mind, I was able to find a couple of ways around this. I think using variables will be the easiest method.

We have GA Director (and GA Services) running on an iSeries. We have set up a network share to the IFS and granted full access to a subfolder on the IFS. However, when we run a project in GAD to get a file from the iSeriesand specify the IFS subfolder as part of the destination file name, we get an ...

You can connect to a SQL database that stores the sequential number, retrieve the number and then update the sequence with a +1. Our method involves stored procedures and a table of different sequence numbers keyed by a file type (AA is an order file, BB is sales, etc). It gets a little involved (to...