Dynamic Data Ingestion

[Dhruv_001]

Hi All,

I am reading specific files from the folder on monthly basis. 

I want idea how to make it more dynamic and efficient.

The following steps I need:

1. Every month workflow will run on specific date, if the file is new the workflow will run but if I haven't received the file from vendor I want my a email notification that file not received.

2. Second if the file is received is same I don't want to over write the data in sql ingestion.. I want my workflow to be stopped and through error and email notification the data is same.

Thanks in Advance