Forum Replies Created
-
Posts
-
Both are possible to do using WMI. here are a couple of samples that can get you started:
[url]http://geekswithblogs.net/sthomas/archive/2005/03/08/25791.aspx[/url]
[url]http://blogs.msdn.com/darrenj/archive/2004/03/30/104135.aspx[/url]thank u very much for your reply.
I was able to save the file suspended manually to my disk.
Can u tell me,is it possible to do this automatically .That is,detecting all the file suspended automatically and sending to a folder in the disk.kavitha
If the file was picked up by biztalk, but failed processing, it should normally have been suspended, so you should be able to use HAT to find the message and save it as a file to disk again.
1.verify your source file nameapce:http://RefillmentSchemas.Request same as sourse schema yet orch\\receive port. still problem not solved
2. create a xml disassembler and add xml disassembler yet receive location.
Nar-
There was a failure executing the receive pipeline: \”Microsoft.BizTalk.DefaultPipelines.XMLReceive\” Source: \”XML disassembler\” Receive Location: \”C:\\Labs\\KanbanSystem\\FileDrops\\Input\\*.xml\” Reason: Finding document specification by message type \”http://RefillmentSchemas.Request#Request\” failed. Verify that the schema is deployed properly.
any help is appreciated !
Found the problem.
The .ddl was badly installed into the GAC. With drag and dropping, this worked well.
I used a variable for the RawString instead of a Message.
yeah one more question
i put in this select statement:
SELECT ID, ORDER_ID, PRODUCTNAME FROM Articles FOR XML
but it doesn’t work :s (in my sql editor it does) if i delete for xml still doesn’t work…
thx for the help
1.How can we use Windows Message Queing(MSMQ) and MSMQT adapter available in Biztalk together in a single project?
2.Can MSMQT Adapter be used on Recieve Port?
3.Can MSMQT Adapter be used on Send Port?1. and 2. in previous reply are options not steps.
Option 2 Add Adapter Metadata is the preferred option.
You need to add the schema to your project.
1. manually create the schema to match the SQL output – not for the faint hearted.2. Let Biztalk/SQL create the schema for you – the preferred method.
Project -> Add -> Add Generated Items…
Add Adapter Metadata -> Add
Select SQL -> Next
Set connection string -> Next
Specify the target namespace ( a unique string)
Select Receive Port
Specify root node -> NextSelect \”Select statement\” -> Next
Enter your select statement, which should end in FOR XML -> Next
Finish
o i see,
but what i don’t understand, i must configure my receive port in biztalk orchestration to receive a message. this message i create must be of a xml schema. but how do i know how this schema will look like if i don’t have an example of the receiving message of the sql adapter?
Any explenation on that?
thx
ThomasBTS06 was never meant to be released on Nov2005, that was always meant to be just the marketing product launch to make it coincide with the SQL and VS launch. However, it was always known that RTM would be a few months after that (I agree the press releases were a little confusing).
As for the rest, no, you cannot run BTS04 with SQL 2005, it is not supported and doesn’t work.
Hi,
I have this situation:
the database db1 is filled with all orders. when this database (or table) is changed he must be copied to the database db2 so the application that works on db2 must have the correct databasevalues.in bizTalk i must add a SQL port who receives the changes. but i have heard that the SQL adapter has a polling scheduler.
then my question ishow does this work? how do i configure my BizTalk orchestration so this can work?
Thx in advance
Thomas
