hi all,

I NEED TO IMPORT MULTIPLE FLAT FILES WITH DIFFERENT FORMATS INTO DIFFERENT TABLES OF THE SQL SERVER DATABASE AND NOT ABLE TO FIGURE OUT THE BEST WAY OUT IN SSIS TO DO SO...

PLEASE ADVISE THE POSSIBLE METHODS IN SSIS TO DO SO AND IF POSSIBLE THE PROCESS WHICH CAN BE DYNAMIC AS FILE NAMES OR COLUMNS MIGHT CHANGE IN FUTURE.

• Moved by SathyanarrayananSMVP, Moderator a few seconds ago Moving from TSQL

AK1987,

The best way to handle this is by using Script Task. Put all your flat files in one folder and then loop them using script task. You can create table on the fly (dynamically) in the script task itself and then load them using the bulk load.

The tables which you are creating should be with the file names for your recon else you can choose your own naming conventions.