|
Home > Archive > BizTalk Server General > November 2004 > Processing order
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| James Longstreet 2004-11-24, 5:52 pm |
| Is there a way to specifiy the message order processing of BizTalk?
I have a bunch of database updates in files, and I want to push them into
the database through biztalk in date/time order.
Is that possible?
Thanks
| |
| Alan Smith 2004-11-24, 5:52 pm |
| Hi James,
Possible, but maybe not easy. First, is the date specidied as part of the
file name, the file date created, or is it content within the file its self.
If the date is specified in the file its self, you could look at building a
sequentiel convoy aggregator, and sorting the messages by date, this requires
a bit of Orchestration design knowkedge.
If you can provide some more details, im sure either I, or one of the others
here can give you a few pointers.
Regards,
Alan
"James Longstreet" wrote:
> Is there a way to specifiy the message order processing of BizTalk?
> I have a bunch of database updates in files, and I want to push them into
> the database through biztalk in date/time order.
>
> Is that possible?
>
> Thanks
| |
| James Longstreet 2004-11-24, 5:52 pm |
| Hi Alan:
thanks for the reply.
First if anyone know how biztalk file adapter processes files I would be
interested in knowing.
second, The datetime is in the filename, and in the schema I am receiving.
I am doing the following:
a) Recieve pipeline reads in Classic ADO xml saved files.
b) Pipe component splits that file into one message per database table in
ADO.NET xml format
c) Orchestration takes message determines destination data table
d) orchestration does transform
e) Message submitted to custom adapter
f) Adapter inserts the data into the data table.
not sure if that helps, it's as clear as mud!
"Alan Smith" wrote:
[vbcol=seagreen]
> Hi James,
>
> Possible, but maybe not easy. First, is the date specidied as part of the
> file name, the file date created, or is it content within the file its self.
> If the date is specified in the file its self, you could look at building a
> sequentiel convoy aggregator, and sorting the messages by date, this requires
> a bit of Orchestration design knowkedge.
>
> If you can provide some more details, im sure either I, or one of the others
> here can give you a few pointers.
>
> Regards,
>
> Alan
>
>
> "James Longstreet" wrote:
>
|
|
|
|
|