File to SQL without orchestration

Home Page Forums BizTalk 2004 – BizTalk 2010 File to SQL without orchestration

Viewing 2 reply threads
  • Author
    Posts
    • #22146

      Hi Guys,

      I am trying to do a very simple project i.e. trying to send xml file as an input to the sql server using Biztalk without orchestration beacuse somebody told me its possible to deploy above even without orchestration

      Steps i took:-

      Created a Receive Port and a Send Port under Biztalk Administration console and configured the port

      Created Input xml Schema xsd and another xsd for sql insert using Add generated items and gave the same targetnamespace and response code what i gave while configuring Send port to database

      Now I added a map using add item and made the links between source and destination schema

      Build and deployed the project and configured the administration console and everything looks fine

      Now when I start the application and give input xml to input folder it disappears from in folder but no records are inserted into sql

      I try to check in group hub and found initially under Retrying and Idle ports as dehydrated message and later into non resumable and gives error

      Please let me know where i am making mistake

      I would  also like to know what to do with orchestration which is automatically created while creating insert schema for Sql, Is it possible to do file to sql project without orchestration

       

      Thanks

       

      God Bless

    • #22162

      what is the error? 

    • #22166

      It sounds like you missed adding a filter on the Send Port.  The error you probably saw in Group Hub was probably a subscription error.  BizTalk didn’t have any subscribers waiting for that message.  You can create a fiter that is based upon the BTS.ReceivePortName.

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