chuang4630
asked on
How to use SSIS to import data file by looping though the files in the folder?
How to use SSIS to import data by looping though the files in the folder?
Suppose we have data folders as follows:
C:\DataImport\FTP\Transpor t\In
C:\DataImport\FTP\Market\I n
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.
Suppose we have data folders as follows:
C:\DataImport\FTP\Transpor
C:\DataImport\FTP\Market\I
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER