Forum Replies Created
-
AuthorPosts
-
Right, you use the flat file schema wizard to generate the schema to consume CSV files. This bog has some info about consuming XLS files: http://geekswithblogs.net/atblog/archive/2005/06/01/41394.aspx
So, If it is a CSV file, I can directly generate a flat file schema using flat file schema wizard to generate schema, right?
can you please explain how to transfer XLS file to XML file
Thank you
You are right Greg,
the POP3 adapter uses a host instance which runs on both servers.
Stopping one of these instances completely removes the warning.
Only trouble is that I’m required to have a redundant system, hence i have similar host instances on both servers.
I’m thinking that maybe my loadbalanced configuration isn’t such a great idea after all…
I’ve read som articles about the “pros and cons” of different Biz Talk architecture, but i don’t think switching the configuration this late in the project is a feasible solution…
June 30, 2008 at 4:53 AM in reply to: Receive Location scheduling is not reflected in Binding files #20018Looking at the bindings files we have here, I can’t see any obvious place for them to be!
It was something I hadn’t picked up on before – but it seems strange that the Send ports have all that information in the bindings (true/false, start/stop etc) and the receive ports have none.
If anyone knows the answer I would be interested too 🙂
Thanks for those responses but I guess I should have included something else. I have no control over the orchestration that runs at 7am. It is out of my hands. Which is why I was hoping that I could throttle it in a setting somewhere. If I were to use a singletone I would have to redesign the orchestration and I cannot do that.
Here is a response from a friend of mine ( here is his blog page by the way … http://connectedthoughts.wordpress.com I highly recommend it 🙂 )
****************************************************************************************
At least in BT 2006 you can create a host and host instance dedicated to the solution then modify the value for the AgentThreadPoolSize registry entry to limit the number of running orchestrations for that host. Not sure if this exists in 2004.
****************************************************************************************That is the kind of thing I was hoping to do. I haven’t checked it out yet though.
You could probably do it with some code. You can use the BRE API to run policies from code, and you can call code from actions, so theoretically you could call a policy from an action.
There is not an out-of-the-box way to process XLS files. BizTalk does a great job of processing CSV and XML Excel files. If you can save the Excel file as XML, you can configure BizTalk as you would for a normal XML file. A CSV Excel file is just a flat file. You can use the flat file schema wizard to generate a schema for the file, and use a flat file dissasembler pipeline component to receive the flat file into BizTalk.
You should be fine using the BizTalk Singleton orchestration design shown there in the picture (just remove the last delay node – that exists to prove a point, not show a good design). If you want a good reference, read the MS white paper referenced on that blog. Basically, you want to receive the first message (file), and then loop. The problems referenced in the previously mentioned blog shouldn’t be your concern since you mentioned you only get new files once a day. Hope this helps!
have you checked the last two issues of Biztalk Hot Rod magazine? Scott Colestock speaks to throttling in those two issues. I am not sure if all of it applies only to 2006, but it might give you some ideas.
Also, check out Richard Seroter’s blog post found at…
http://seroter.wordpress.com/2008/05/19/biztalk-orchestration-throttling-pattern/
It is an implementation of the pattern that Scott Colestock refers to in his articles.
Unfortunately there is no “switch” that you can flip that would easily say “Only allow N instances of this orchestration to be active or dehydrated at any one time”
Hi Jerry,
You would push the Excel files to MSMQ for BizTalk just like you push any file to MSMQ (using System.Messaging or WCF). WCF-MSMQ is the way to go if you are using R2. The core transport is still MSMQ, you just use WCF to read and write to the queue. MSMQ does have a hard size limit. 4MB sounds about right. It sounds like you won’t come close to that limit, but if you do there are a couple of options. You could write code to chunk the files, send them to the queue, and then reassemble them on the other side. Alternatively, you could drop MSMQ altogether. The BizTalk message box itself behaves like a queue, so in many cases you don’t need MSMQ if you are using BizTalk. For example, you could set up a 2 node BizTalk group with a WCF http receive location on both servers and put them behind a load balancer. Now you have a highly available, load balanced channel into BizTalk. You can send a message into BizTalk via WCF, and it is automatically queued up in the message box.
Yes, I have removed it from the store procedure sql statement.
hello greg,
thanks for the response..
yeah the new servers are going to be exact copies.I remember last time,in a small test environment, we had to rename our sqlnode(no cluster here); after that we reconfigured the BTSAdmin on the Biztalk nodes to pick up the new name for the server hosting the Mgmt db. We could never get Biztalk working post that.
I now wonder if it was because we did not run the 2 scripts??
we had un-installed and re-installed Biztalk then and then all the BTS applications.regards,
Did you remove the XMLDATA instruction from the stored proc after you generated the schemas
Notification services are not supported on SQL Server 200 Personal Edition, you will need to upgrade to Standard or Enterprise edition
HI,
I am having the same issue as posted origanally. I have a simple query in SP “Select Cols from Table XML AUTO,XMLDATA”. I create schema and deploy the project succesfully. But problem occurs when i try to create a receive location for SAL adapter. It thorws message of “Invalid schema” for every schema generated within the project. I am wondering what could be the problem?
Thank you in advance.
Raminder
-
AuthorPosts