Thank you for sharing this, Ranjan. Would it be possible to fetch a file based on latest date. I am receiving same files with dynamic dates appended to name everyday. Something like FILE_TAX_20230321 and FILE_TAX_20230322, after Mar/21/2023, I have to go for Mar/22/2023. How do I achieve this. Any assistance on this will be much appreciated.
Option 1: Use pattern file_tax_*, so that the files with dates will be picked. Option 2: put the file name in an indirect file or file list through a script, then use file list option. While using both of the options, u need to move the files to other location after files are ingested.
Please create a video on how to do mass data ingestion from on-premise sql server to Azure Dataverse using IICS. All the 2=3 types: One-time, Incremental and Full data along with Incremental
