I need to redirect only errors rows to azure storage container in .txt or any format.
I have Azure sql source and dynamics 365 target.
Redirect errors in copy activity
Hey,
Please follow the below link :
https://docs.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance
Section : Monitor skipped rows
@NandanHegde-7720 Fault tolerance will not redirect error rows. it will publish error details. Please check format of error details in the link which you shared. I need only error rows.
Thanks for your query and reaching out in Microsoft Q&A Forum. With the current behavior of 'Fault tolerance' in copy activity, it logs all the error rows along with few additional details like error details and timestamp. But there is no out of box feature which can redirect only the error rows.
If you have any additional feedback or feature request to improve this feature functionality I would recommend you to please log a feedback here : https://feedback.azure.com/d365community
All the feedback shared in this forum are actively monitored and reviewed by respective product owners.
Please do share the feedback link once it is posted so that we can take it forward to ADF product team.
As a workaround you may have to have an additional process after your copy activity to look for the the log file and truncate the data to remove the extra columns like timestamp and error details.
Hope this info helps. Please do let us know if you have further query.
Please don't forget to click on
and upvote 
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is howWant a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
We still have not heard back from you. Just wanted to check if the above info was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
7 people are following this question.
