How to use SSIS to import data by looping though the files in the folder?
Suppose we have data folders as follows:
The file types can be: .zip, xls, csv and xml.
How do we dynamically configure the data source to achieve the goal?
The destination is always SQL 2008R2.