|
|
||||||
|
#1
12-16-08, 07:19 PM
|
|
|
|
|
Hi,
I have orchestration with the following steps 1. Receives the orders batch file. 2. Debatch the orders 3. Loop the Orders 4. One more loop for the Order Items 5. Inset the Order line itesm in to SQL table 6. Execute the stored procedure to load the order to the system If the Ordered Delivary Option in SQL send ports is checked then the above steps works fine and if not then it will not load all the records. Can you please explain what the option is and also I see the service instances still runs even after the orchestration completes. |
|
|
|
#2
12-16-08, 08:50 PM
|
|
|
|
|
Well, like the name implies the Ordered Delivery option will make sure
that the adapter executes in FIFO order, but it also means the adapter will be slow as a result. I think there are some better options for you to do what you want. See my blog posts: http://www.novaenterprisesystems.com...r-(Ab)Use.aspx and http://www.novaenterprisesystems.com...t-(Ab)Use.aspx For some more information. I think this is a common mistake people make, you can basically batch a bunch of SQL statements and send them all at once. It will then process all or nothing. Best of all you can use Maps instead of XPath to assign messages. I hope this helps. Please feel free to post back with any further questions. Kind Regards, -Dan Rosanova http://www.novaenterprisesystems.com |
|
|
| Similar Threads | |
| Ordered list inside ordered list I'm wondering if there's a way to support ordered list inside an ordered list. In other words, the ability to create multi-level structures such as 1. Products 1.1 Pen 1.2... |
|
| Delivary Options Trying to figure out whey one of my email accounts is set up to send emails and a specific time and will not allow me to change it. I go into the options and change it, but... |
|
| How do i set the delivary report time same s sent time? When i sent the delivary report time to 10:00Am and i sent that message at 8:00 am. It's showing receiving time of 8:00 am on the receiver mail id.. But i want the 10:00am on... |
|
| SQL Server 2005 ordered view - not ordered ? Hello, In SQL Server 2005 I have a view which should return ordered data from table. create view View1 as select top (100) percent f1,f2,f3 from T1 order by f1,f3 go but if... |
|
| Option Commands (Option Explicit / Option Base etc) - Scope Hi All, I have my VBE set to always use Option Explicit at the top of each new module. I occasionally use Option Base 0 or Option Base 1 as required. If I use one of those... |
|
|
All times are GMT. The time now is 12:30 PM. | Privacy Policy
|
Ordered Delivary Option