I’m trying to find out if there’s any way to read in a table from a Microsoft Access database. Using GoAnywhwere. I chatted online with Duane and found out there's no Access JDBC driver available but was wondering if I could somehow use an ODBC connection set up with an Access driver? Just don’t wan...

Rick As we discussed I changed the version number on the Set Variable task from 2.0 to 1.0 and the project worked! The older version doesn't require setting the cursor to the first row. <setVariable label="Set Variable PrevMnth" name="PrevMnth" value="${LstYrMnth[1]}" version="1.0" /> Thanks again f...

Thanks Rick - appreciate the help. It is a rowset being returned from the database (Teradata in this case). I did try adding the [1] to the rowset name and got the following: Project '/PaulR/TestDeletes' failed. Job number is '1387133248712'. [8099 - Set Variable PrevMnth] An unexpected error occurr...

Thanks Rick. I retrieved the date using a SQL task, with a variable in the Output Variable option. 1) When I write the retrieved and formatted date to a text file (using Write CSV task) I see the correct date with format yyyymm which is what I'm expecting. 2) When I assign this value to another vari...

I need to create a project to calculate a yyyymm value from a database. Then need to issue a multiple delete files task with the yyyymm value as part of the filename on a local file system. I have been able to retrieve the yyyymm string from the database (and write it to a .csv file) but have not be...