- This topic has 7 replies, 1 voice, and was last updated 5 years, 4 months ago by
.
-
Posts
-
-
Hi,
I have used biztalk orchestration for the purpose of inserting order from one database to other database. Order consists of some data and attachment. In attachment number of file are present.
I am able to enter order from one database to another database. But stuck with problem of transferring files from one database to another database. Does anybody knows how to transfer from one database to another database using biztalk orchestration?
Thanks in advance
-
Sorry guys,
In above posted issue i have mentioned that we want to transfer file from one database to another database…Here i want to correct my mistake that i want to transfer files from one location to another location regardless of its content.
-
hi Stephen,
We have multiple files to be transfer, so is it work for the same?
Can you just tell me how to add FILE adapter without using orchestration?
Thanks
-
thanks
but we want input path and output path both to be taken from a database and both from different database so path to folders will come at runtime
and in send port for file the filter cannot be given *.* we have to give *.zip,*.txt etc
but for receive port *.* can be given
-
You do not really need any Orchestration for this.
You could just use BizTalk messaging.Create a Receive Port using the File adapter to pick up your file using *.txt, *.xml, *.*, anything. Make sure you use the Pass Through Pipeline.
Then, create a Send Port using the File adapter and Pass Through Pipeline. Create a Filer on the Send Port using BTS.ReceivedPortName = your_port_name.That should do it.
-
It’s rather easy to do.
You might want to look at the SDK sample on Messaging or the Virtual Lab (http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032281097&EventCategory=3&culture=en-US&CountryCode=US). The Virtual Lab in on 2006 but the concept is the same.
-
I think that would require a custom adapter to get the file paths on the Receive Side to be totally dynamic. Or, what I have done in the past is just use file IO inside an Orchestration to read an Xml Document. That would be much faster to develop.
You could then use dynamic send ports to send the file to any place you wanted with any name you wanted.
Hope this helps.
-
-
-
-
-
-
Empire of Lies : Raymond Khoury : 9781250210968
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.