Hi @SubbaReddy Kovvuru ,
CSV is a very simple format, and does not have the concept of a "sheet", so you could not load data into sheets in csv file.
Excel should be more suitable.
And it also depends on the metadata (structure) of the database tables.
If all the tables with the exact same structure, we can use an Execute SQL Task to return the table names with an object variable. Then use a foreach loop container uses this object variable and contains a single data flow task. Otherwise you would need separate data flow tasks for each file. Because the metadata for a data flow cannot change during runtime in SSIS and it will be fixed at design time when you map from source to destination component.
Useful links: Using-the-Foreach-ADO-Enumerator-in-SSIS
How-to-load-data-from-multiple-Excel-sheets-to-any
Regards,
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.