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