Hi Skyvia Support,
I have a number of import packages that import csv files into a SQL database each day using the File Mask method. However, I have a new scenario I would like advice on how to handle.
I have a new SCADA server which automatically creates CSV files each day. These files sit on the SCADA server until the files are downloaded manually ~once per month. I can create a PowerShell script to merge all the CSV files into one big CSV and import that single file, but I would prefer to import each file individually to make it easier to manage especially if there is an issue importing a specific day and an error appears.
How do I setup the Integration Service to import and iterate to the next file once the first import has been successful, then import the next file once the second file has imported successfully and so on. Does a feature exist? Can you send me some instructions on how to set this up? Thanks.