is it possible to insert, update records on a table directly inside a orchestration

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › is it possible to insert, update records on a table directly inside a orchestration

Viewing 2 reply threads
  • Author
    Posts
    • November 28, 2008 at 4:43 AM #21275
      community-content

         Hi

        I would like to do following things directly inside a orchestration if possible. [:)]

        1. insert a incoming message into a certain SQL table with properties.

        2. after doing a map – I want to update same record with the inhouse message format.

        3. after doing another map – I want to update same record with the outgoing messageformat.

        We have be doing this for a while by custom pipelines – but on this project I would like to do the same from inside a orchestartion

        Is there any who has had the same issue or problem ???

        Thanks….

        /Peter

      • November 28, 2008 at 6:56 AM #21276
        community-content

           

          Not sure about what you are interested in.

          But try to use SQL adapter. Create BizTalk project in Visual Studio and use SQL adapter special wizard (in VS) for generating Ports and Schamas for Database table Insert and Update operations.

        • November 28, 2008 at 6:59 AM #21277
          community-content

             But keep in mind that SQL Adapter operations are not enlisted with current transaction…

            That is your Inserts and updates (done with SQL adapter) won’t be rolled back on error.

            Use Custom Code to acheive SQL transaction support.

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.