I have a hosted database that contains several tables and I am writing a script that needs to be able to import several fields from Table2 into Table3. I have no problem creating the filepath to the database and mapping the fields...BUT I cannot get the script to reliably select Table2 as the source table. The first time the import is done each day it will default the source table to Table1...but all subsequent imports will behave correctly (selecting Table2).
Is there any way to specify the SOURCE TABLE in the path file so that it will select correctly every time? Other thoughts?