question

sankket87 avatar image
sankket87 asked

ssis import excel 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 DFT fails 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 with some correction, can anybody help me out in this case. I am new to SSIS development, I appreciate any help. Thanks!!!
ssisfailediterationfailingfail
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.