sqladapter

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › sqladapter

Viewing 1 reply thread
  • Author
    Posts
    • December 13, 2005 at 4:43 PM #12522
      community-content

        hi

        is it possible to take data using sql adapter of type receive and send data to sql adapter of type send to insert records in database

        we are able to use sql adapter of type receive to query data from database but output is in a folder i want output to be used to give input to next sql adapter

        but schema matching problem comes i guess?

      • December 13, 2005 at 7:49 PM #12523
        community-content

          This is exactly what Biztalk is designed to do.

          You do not need to match the schemas, you map the messages.
          Just create a new map using the schemas generated by each SQL adapter and connect the fields. Add a transform shape to your orchestration between the receive and send.

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