Debug an orchestration in biztalk 2010
===

I'm making an orchestration to send data from one SQL Server DB to another one. I'm able to receive the data but unable to send it to the other DB. I made a send port to test what I'm getting as an input. I got to know that I'm not getting the right data from the source schema. I have tested the map from visual studio 2010, and it is working fine. But i'm getting following error in event viewer:

    The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"     
    Description="SQLOLEDB Error Description: Empty update, no updatable rows found  Transaction aborted "

     <Root xmlns:ns00="urn:schemas-microsoft-com:xml-updategram">
          <?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB Provider for SQL Server" Description="SQLOLEDB Error Description: Empty update, no updatable rows found  Transaction aborted "?>
     </Root>".

I want debug the orchestration. How can I do so?