This code was working when initially written. However the “File” variable does not initialize when run. This is from an incremental load script, and it has been run previously. I have changed to a different project using the same incremental load script. The 'File' variable still has a value from a previous project, and I am not able to clear it.
I have also used
LetFile = Null;
LetFile = Null();
to initialize the variable, but it always keeps the '<null>' value, and never initializes in the script.
I have tried to use a new variable, 'File1' and it will also not initialize, meaning it's always '<null>' when running the load script.
Sorry for the delay in responding. You're correct. The 'Filelist' was not generating the correct path. It has to do with how I was specifying the path using variables and '*.' instead of just '*'. I moved the '.' inside of the variable where I specified the file extension, and it works great. I also removed the $() around the FilePath.