Unanswered: Best solution for importing multiple files from a folder/timed event
I am looking for a few things here:
1. I need to be able to import a list of separate files from a folder that are all in the same format (flat files). It's been a while since I have worked with an optimized import process like this. The files all have different names but are the same length and end with a character that determines the status of the file.
2. The importing needs to occur on a scheduled basis. I know this means the database will need to be running at all times...
Any feedback or referrals to the correct existing thread(s) would be great!