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