[community-content]

It sounds like you could use Direct Binding to accomplish this.

What does this mean:
“And how can I ensure that each incoming message has a unique generated message?”

You will need to use a Parallel Convoy, I think, to get the two messages into one Orchestration. You can find samples of that on the site.

[community-content]

I think your Send Port is messed up. Did you use the SQL Adapter to generate your outbound schema?

I’m not an SQL Adapter Guru but see if Todd’s white paper helps: http://msdn.microsoft.com/library/en-us/BTS_2004WP/html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp?frame=true&_r=1

[community-content]

I have not really seen people want a crystal report generated in BizTalk.

BizTalk has its own Business Reporting tool called Business Activity Monitoring.

Hope this helps.

[community-content]

Hello.

I would use custom XSLT with input parameters of your input message like Name, Project, Day1, Day2, and ext. I think you would have 16 parameters total.

Then, I would use code like this inside a Script Functoid – using XSLT Template:
<xsl:template name=\”yourNameHere\”>
<xsl:param name=\”param1\”/>
<xsl:param name=\”param2\”/>
<xsl:param name=\”param3\”/>
<xsl:param name=\”param4\”/>
<xsl:param name=\”param5\”/>
<xsl:param name=\”param6\”/>
<xsl:element name=\”General\”>
<xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
<xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
<xsl:element name=\”Day\”><xsl:value-of select=\”$params3\” /></xsl:element>
<xsl:element name=\”Time\”><xsl:value-of select=\”$params4\” /></xsl:element>
</xsl:element>
<xsl:element name=\”General\”>
<xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
<xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
<xsl:element name=\”Day\”><xsl:value-of select=\”$params5\” /></xsl:element>
<xsl:element name=\”Time\”><xsl:value-of select=\”$params6\” /></xsl:element>
</xsl:element>
</xsl:template>

Note this is not complete.

Hope this helps.

[community-content]

hai friends,
I want to send datas from xml file to sql database with sql adapter and updategrams.
I configured receive port to use file adapter and send port to use sql adapter.
In the receive folder,when I put the file xml ,it vanishes but it does not insert in the sql table.

It gives the following error

The adapter failed to transmit message going to send port \”SQL://KAVITHA/bizTest/\”. It will be retransmitted after the retry interval specified for this Send Port. Details:\”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name\”

The adapter \”SQL\” raised an error message. Details \”HRESULT=\”0x80040e14\” Description=\”Impossible to find stored procedure’s name.\”

My question is Does updategrams use stored procedures?
Why it is asking for stored procedures?

Can anyone help me?
Thank you

[community-content]

One more thing:

I tested the procedure with SQL Query Analyzer and it worked very well.

Another thing is that I’m working with 2 BizTalk servers. On one server this project works fine, on another it gives me this error.
But I can’t find any differences between the settings of this 2 servers.

[community-content]

Hi there,
I am having a problem in mapping in Biztalk using functoids

Input :

<UserInfo>
<Name>Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Mon 3</Day>
<Day>Tue 4</Day>
<Day>Wed 5</Day>
<Day>Thu 6</Day>
<Day>Fri 7</Day>
<Day>Sat 8</Day>
<Day>Sun9</Day>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>8h</Time>
<Time>0h</Time>
<Time>0h</Time>
</UserInfo>

Output :

<General>

<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Mon 3</Day>
<Time>8H</Time>

</General>

<General>

<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Tue 4</Day>
<Time>8H</Time>

</General>

<General>

<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Wed 5</Day>
<Time>8H</Time>

</General>

<General>

<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Thus 6</Day>
<Time>8H</Time>

</General

<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Fri 7</Day>
<Time>8H</Time>

</General

<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Sat 8</Day>
<Time>0H</Time>

</General

<General>
<Name> Vishal Dube</Name>
<Project>Project Name</Project>
<Day>Sun 9</Day>
<Time>0H</Time>

</General

Please help me with these and as soon as possible

With Regards,
Vishal Dube

[community-content]

About the only thing I can think of is to look at the message context properties of your two messages. The one that works and the one that does not work.

You can see these by turning on tracking in HAT on the pipeline.

I’d be looking for something not present or being changes on the Envelope.

Just a thought.

[community-content]

Have to use the .Net classes for the string concatenation.

[community-content]

hai friends,

I want to transfer the datas from Excel to SQL via biztalk server 2004.
can anybody give me a clue to start my project.

I defined the xml structure and mapping.

I need the following details
1)How to configure receive and send ports.
2)Which adapters to use
3)Do I need to write any C# code

Can anyone help me?
thanks in advance

[community-content]

hai friends,
can anyone suggest me a good book for learning biztalk

[community-content]

Sorry, I have not been following the full thread

You might have already said this, but how are you initializing the Correlation? On the Send or the Receive? Make sure you are doing so on the Send Shape prior to the Receive.

Also, in the Subscription Viewer was the record you get this data from something link “XLANG\\” or like “Activate”?

[community-content]

Hello.

Check out this sample: http://www.biztalkgurus.com/Samples/Property-Promotion-Demotion-Pipeline.html

I think you can promote . demote your value to the File.ReceiveFileName property. Then, use the %SourceFileName% macro.

Don’t know for sure if you can override / set this easily in the Send Pipeline. That might need a custom pipeline component to do that.

Hope this helps.

[community-content]

Hello.

I didn’t have a problem.

Make sure you have the input type set to XML and not the default Generate Instance. Also, you might want to make sure you build the solution first. This was build pre-sp1. I had some problems getting the Test Map option to show up. I have to reopen Visual Studio.

Let me know how this works.

[community-content]

Nishal’s Blog has a great post that walks through a new Biztalk project step by step:

http://biztalkblogs.com/nishil/archive/2005/10/26/57.aspx

It is a great example of a content based routing solution using biztalk.

[Author]

Posts