The following method has worked well for me:
Use Insert File to insert the file with the "store a reference" option enabled, into a container field. You can then set a variable to the file path in the container field.
GetValue ( ContainerField ; ValueCount ( ContainerField ) )
extracts the file path.
You can get filename as
Let ( cd = Get(CurrentDate) ; DayName(cd) & Day(cd) & ".csv" )
then use it in variable.
You need 2nd line of file path as exising (example) file in "Import Records" script step, so that script edtitor can get fields from example file for mapping when making script.
Thank you all,
But I believe I have to Rethink my Import Routine. Not Sure what I was Trying to Do. I do not want to have to Run this Script everytime there is a File. The Files can Stay until I choose to Run the Script and I want as Least User involvement as I can. Ill b back
The concept behind my suggested method is this:
When you want to import, you run the script. An open file dialog opens where you find and select the file you want to import then click "open". The script does the rest.
The method does assume that the file type and the row/column structure be the same in each file, but the name and location of the file can be different every time.