I need to travel a txt file folder where you have the txt file names are in a sql table
with the following structure.
I was checking the internet and there is a Foreach Loop Container control that lets go flat files. What I need is to develop an ETL to scroll through the txt files based on a table. Each time a file is loaded only the state changes and would load the files where the state does not change. For example: Select Filename from TbConfiguracion Where Status = 0
Have some example. I thank you in advance for your time.