Forum Replies Created
-
AuthorPosts
-
September 6, 2006 at 10:14 AM in reply to: load data with file to database oracle and SQL Server in biztalk #15576
This job will do SQL Adater, Comes with BizTalk, u can use Datagram and create a schema. then map from flat file schema to SQL Schema.
You can workout StoreProcedues or Querys, both workes here.
BizTalk 2006 got Oracle Adapter too….
Hope it helps you.
Nar-
In the past, I have set up a one to one relationship between solutions and applications. Mostly because that made the most sense for the project I was working on because the application would always be deployed and removed as a single unit of work. I can’t see a reason why you couldn’t have more solutions but I try to organize the applications more than the solutions.
If you are talking about a whole lot of artifacts, breaking it up would make sense more from a size point of view. It probably wouldn’t hurt to put the full deployment on each server since you never know when your Receive Server might need to be a Send Server plus then you’d have to build and maintain multiple installation packages.
I’d create a common shared application. Then have the others reference it.
I don’t have any hard set rules. The key is to make deployment and manageability easy and structure things logically. In the 2004 days (before applications), one project I was on had a few solutions, and about 40 projects. A few Orchestration, a few pipeline, and then many projects with schema and maps for vendors.
Hope this helps.
Does the following code sample help?
Thanks for the reply.
.net 2.0 RTM was installed. We gave up, reformated the spindle, and reinstalled the o/s. Tommorow I will try installing BT again.
I had the same problem and wasn’t able to set the file name.
I’m not sure the name is even there. You might need to do some pipeline work to get the part name.
FYI – It appears I can get my email notification if I set the Send Port filter to "BTS.AckID | EXISTS".
Have you tried using the string function on the xpath:
xpath(PostCodeMsg,"string(/*[local-name()='Root' and namespace-uri()='']/*[local-name()='PostalCodes' and namespace-uri()=''][recCount]/*[local-name()='PostalCode' and namespace-uri()=''])");
Is the "Activate" property of your Receive shape in the orchestration set to True? If not, it should be …
I get "Suspended (resumable)" on a message in the following scenario:
– POP3 adapater
– Apply MIME decoding = true
– Body Part Content Type = text/xml
– Body Part Index = 0
– send an email with not attachments of type "text/xml";This specific error is: "The MIME decoder cannot find a MIME part for the specified content-type. Either there was no matching content-type or there were not enough occurrences of it."
I need error notification when this happens.
When this happens it appears the ErrorNotification object is NOT created.Any guidance?
Thx,
PhilMy apologies – not dehydrated, rather showing as "retrying and idle ports".
Phil
Yes, and just retried it.
Again, my transaction is dehydrated and I terminated from the Admin Console.
Phil
I can not get to work.
If I use:OriginalFileName = MsgPart.Name;
My email message gets dehydrated.
And the SaveFile generates an error; do I need to be referencing a specific library?
Any positive direcition is appreciated.Thanks,
PhilHave you tried:
msgname = msgpart(MIME.FileName)
[quote user="Stephen W. Thomas"]
If I remember right I did use pass through pipelines.
I’ve never tried to use .contains on the message name. You might have to pass the name out to a .net component that does this check. Also, you might want to set an Orchestration variable to your name and then use this to set the part name and pass to the component.
Hope this helps.
[/quote]
Hi!
The problem is not .contains , I've tried it with default values and it works.
It seams that,
msgName = msgPart.Name;
doesn't return the filename. Is there any way to "print" out the variable msgName from the orchestration?
I’ve not seen this error before.
Seems like a problem with the .net 2.0 framework? Guess I’d make sure you have the RTM and not some older beta version.
Hope this helps.
-
AuthorPosts