Insert/update in to SQL database using stored Procedure RRS feed

  • Question

  • Hello Experts,

    I am have created application where we receive a csv file and using stored procedure to insert/update in to the SQL Database. When we  do this if there are any issue with the insert/update it just throws in BizTalk like

    The UPDATE statement conflicted with the FOREIGN KEY constraint.The conflict occurred in database,table.
    The statement has been terminated.

    But never shows which record has failed. I am just checking if there is any way of doing row by row update/ insert using BizTalk orchestration so we know which record fails. Are there any other elegant way of doing this.

    Monday, March 6, 2017 4:27 PM


All replies