Selective Dumping in a Database

Five Stars

Selective Dumping in a Database

I have a scenario to implement which is as follows:

There is one folder which consists of three files (a.csv, b.csv and c.csv).

Now based on the names of the files i want to dump them into a Database like : a.csv into table A, b.csv into table B and c.csv into table C.


How should I iterate over the files and dump them iteratively.  Please attach some screenshot of the job design if anyone has a solution to this.


Thanks in Advance