Monday, May 6, 2013

SSIS: Warning: Rows sent to the error output(s) will be lost.

Warning:

 Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations to receive error rows, or reconfigure the component to stop redirecting rows to the error output(s).


Solution and Explanation:

we can see this warning often in a lookup .
In lookup,  if 'Redirects error output .. ' is selected then use one flat file or oledb destination,  to get the No match output redirected or select some other option like 'Fail Component'.




Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.

No comments:

Post a Comment