as of now i have a solution

i have two steps

1. load the data into stg table based the file name start and end times

2. run another package after the stage...

when the source process complete the last step of the process is to create this .done file.

Hi,

thanks for you reply. could you please help me to understand how it works. will it filter the rows or to get a flag?