the link contained the blog series , with steps to do file looping as well as dybamically change the file path for source connection. In fact there is a youtube video link in there as well. It might be better to read the blog fully .