I've to load data from multiple files in to a table thorough for each loop container in SSIS. If any one of the file got error-ed out then the package stops execution.
Now, i've to move the error-ed file to a different path and continue to process the remaining files.
Any Suggestion?
Look at properties of containers and tasks. There are settings to determine how you want to handle errors. They can be ignored or stop execution of the package.
You can also look at constraints to use different paths depending on success or failure.
Lastly you can look at error handling via events.
Between those three topics you should be able to do whatever you want. There is plenty of blogs, faqs and examples available online.
When you connect arrows to different tasks you can right click and the arrow you drag and it will give you different options. One of the options on the arrows will be continue even on error.
