SQLTeam.com | Weblogs | Forums

SSIS; import multiple files into sql server with error handling


I have task to import multiple excel files into sql server table, while iteration some excel files have header name changed or some times data type issue, due to which DFTfails and NO further iteration and package fails, I want to log file names which got fail and want to continue loading excel file using DFT till the last excel file, and in the end I would like to have file names in one place which got fail, so that I could try again on them wich some modification, can anybody help me out in this case.

I am new to SSIS development, I appreciate any help.