How to insert data into SQL Server without using SQL Adapter

Home Page Forums BizTalk 2004 – BizTalk 2010 How to insert data into SQL Server without using SQL Adapter

Viewing 2 reply threads
  • Author
    Posts
    • #21817

      Hi Gurus

                I have a scenerio where I have to insert data into SQL Tables without using SQL Adapter, can any one help me in this regard.

       

      Thanks

    • #21822

      Hi,

      create a .NET component which inserts to SQL, than call this component from an orchestration.

      Laszlo

       

       

      • #21824

        This component is called in Expression shape rite, so I need to debatch xml’s from a message and then insert these xml into a column of the table, my question is when debatching several xml’s from a message do I need to use one expression shape to debatch one xml or is it possible to use only one expression shape for debatching several xml’s from a msg?  and after that I need to insert these xml’s into their respective columns of the table and can I do this insertion in one expression shape like inserting different xml’s into different tables.

         

        Thanks 

    • #21826

      Can you please share more information? What kind of data do you want to insert? Will the data be available in a message being picked up by BizTalk? Do you need BizTalk for the solution?

      Solutions to this could range frmo creating a dll in c# that performs the inserts and call it from a custom pipeline component or from an orchestration, to creating your own adapter.

      The SQL Adapter is usually recommended though.

      • #21833

        Hi  Thiago

                    I have a msg which contains three records and I have to create xml’s or load xml for these 3 records each of one xml and then I need to insert into a SQL table column, I need to do this How do I do? According to my knowledge I have to do in expression shape so is this correct, if so how do I do it?

        I need to insert data into SQL without using SQL adapter, what I am thinking is I need to write a .net component and call those methods in the expression shape, is this correct?  and can I use one expression shape for inserting 3 different values into 3 different tables?

         

        Thanks

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