CODEWITHSUNDEEP
ssisforeach-loop-container
PaDideh
PaDideh

Reputation: 1

Read multiple CSV files from multiple folder and import to a SQL table through SSIS

I have a main folder(Digikala) and every day, a new folder by date name will be added to the main folder. In these folders I have multiple CSV files, I need to read the folder named with the current date every day and insert the 10charchter of each CSV file name as a new column in my table in SQL. How can I do that in SSIS? I know the solution in "For each loop" but I can do this only for one of the folders, As I mentioned it is a daily task, and I need to do it dynamically because the number of folders increases every dy and the number of files inside them is unspecified. Best regadrs

I have tried "For each loop" in SSIS and name variable (to extract 10 characters) but I can do this only for one of the folders and I should specify the path on the folder manually. As I mentioned it is a daily task.

Upvotes: 0

Views: 124

Answers (0)

Related Questions