Ric, Thanks for your response. I must be missing something though because I can't seem to get it to work. Here is a sample of what I am trying to do: <setVariable label="Set File Name" name="MyFile" value="BatchEstimatedCartonizing${userid}${jobnbr}.zip" version="2.0" /> <setVariable label="Set File...

I have a project that creates an Excel file which is then zipped. Is there a way to retrieve the size of the zipped file? The file is created in the project's workspace only.

I am trying to get a record count from a file using a query and SetVariable task. I am using a simple record count as shown below: <sql label="Connect to DB" resourceId="LOCAL" version="1.0"> <query label="Select Data" outputVariable="records"> <statement>Select count(*) From filelib.testfile </stat...

I am trying to import an Excel Spreadsheet to the AS/400 using the Read Excel and SQL Insert functions. When I encounter a cell that should contain numeric data but instead is blank, the process fails. Is there a way to have an empty cell replaced with a zero for numeric fields?