I’m experiencing issues getting an automated task to run correctly using 4.0 Beta. Basically its an automation task that uses a loop dataset variable to input the database name to spit out 10 different files switching the database name in the loop variable each time in just one select to file task. The entire automation works fine in 3.8 and in the 3.8 batch mode through the task scheduler. Now that I’m using the 4.0 beta, this same task works absolutely fine while running in TDP 4.0 Beta itself, its just failing when I use it in the batch mode for 4.0 beta called through the task scheduler. From the looks of the log, its not recognizing the variable for the connection for some reason in batch mode. I’m attaching the log files for both 3.8 and 4.0 for reference. The automation itself has settings I’d like to send separately if needed, so just let me know if I need to send that.
Any way this can be tested in both versions also and see if you run into a similar issue? I’d hate for 4.0 to launch and this issue is present and I have to use two different versions.
Lastly, I use an I-Series ODBC connection on my end for this, which requires the unquote information for the variables to be fed into the queries correctly. Let me know if you need further information. Thanks!
Loop_Variable_Logs.zip (5.36 KB)