sql adapters

Viewing 1 reply thread
  • Author
    Posts
    • #15638

      Hi,

      I'm just a student trying to get my head round how biztalk 2004 actually works. My progress so far is:

      I have just finished the mapping from an external flat file to an internal xml file. The internal schema I will be using for a lot of different flat files. I created my receive port and a send port with a file location and this all works fine. Now I want to create a send port which will pick up the document and then store it in my sql server. They are quite large docs so I just want to store the whole thing under ntext. When I try to create the send port and then choose transport type: sql, it then says that I have to give the document target namespace and response root element from the xml documents received from the sql server – this I don't understand. Do I need to create an orchestration for this? If I do then can I use the same orchestration for each mapping I will be doing? Or do I need to create a different orchestration for each based on the same internal schema?

       Thanks,

      Sharon

    • #15664

      You shouldn’t need an Orchestration in most cases. 

       

      In your case, to accomplish what you want you would need an Orchestration. 

       

      There was a thread on this about 3 weeks ago, it might help: http://www.biztalkgurus.com/forums/thread/4573.aspx

       

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