Hi Phil Parkin and Just Marie,

I am using SQL Server 2012. I found this article which explains on getting the error description.

https://msdn.microsoft.com/en-us/library/ms345163(v=sql.110).aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1

Hi JustMarie,
Thanks for the suggestion.  I have a proc that has the sql which fetches data from different tables and inserts into destination table. I was not able to redirect rows from SQL...