Forum Replies Created
-
AuthorPosts
-
Is it necessary to install MS BizTalk Server 2006 and MS SQL Server 2005 on the same machine?
Are SQL Server client tools (that come with BizTalk 2006) needed to access databases on another machine?
Is it possible to use SQL Server 2005 client tools to access a SQL Server 2000 database?
So you don’t think it is possible to do it quite simply within the script itself?
Well you could build a component that does the trick,
drag it to the gac and use that component in a map…..Thanks Stephan,
As a matter of fact even I installed BTS2006 in 4 systems so far. Even I didn’t encounter any problem.
This is the first time I am facing such problemI don’t think there is a permission problem. I tried again but this time it shows same error but instead of deployment.dll it shows Microsoft.Sql.Adapter.dll
Why it is failing registry service.Is there any way I can mannually register this dll?
Any help would be appreciated.
Is your rule deployed?
This might be because your message type on the input into the rules doesn’t match anything in the Orchestration. Did you import your XSD into the Rules? If so, did you change the message type property? I don’t remember the exact details, but it’s something like when you import the XSD it doesn’t get the full message name in the rules.
Hope this helps.
Did you read through the installation guide? Might be a permissions problem? You a Admin and Network System has the correct folder permissions to the temp drive?
I’ve installed it about 5 times so far – and haven’t seen that error.
The .xsd file describing the text file has a node for the whole document and one for each row.
The document level node needs to have ‘Child Order’ set to ‘postfix’
Even though the ‘commas’ in the actual row are ‘infix’ the document level node is asking where the ‘carriage returns’ (0x0D 0x0A) are in the document and they are postfix – so when this was changed it worked!
Regards
JManThanks a lot
[b:1761eaa790]greg.forsythe[/b:1761eaa790]
Just to let you know:It’s an ideal solution for us. Simple and elegant. Everybody is happy 😀 Thank you once again for your time and kind attitude to beginners!
As a reminder to ourselves (or anyone who will follow up): the orch should contain a configuraqtion for dynamic port
DynamicSendPort(Microsoft.XLANGs.BaseTypes.Address) = \”http://server/ebXml/servlet.jsp?\” + strParameter;I want to send an e-mail message (using an xslt-transform to html-format it) with an attached image-file. The first part is done, but how do I attach a file to the e-mail?
Sorry, I’m not real sure on this.
But, as far as I know if you want extra schemas you need to buy the full EDI adapter.
Best of luck.
It depends on your definition of guaranteed delivery.
It you require guaranteed, once and only once ordered delivery then you need to use a protocol that supports this i.e. MSMQ, MQSeries and in the future WCF.The other adapters provide a level of acknowledgement. And will retry a number of times to deliver the message and provide ACK/NACK messages if you use [b:3f5eb3bdaa]Delivery Notification[/b:3f5eb3bdaa] from an orchestration or suspend the message if you don’t.
The HTTP adapter requires a 200 response from the remote Web server, The FILE adapter needs to successfully write the file to a disk. The SMTP adapter only needs to send the message to the first SMTP gateway server.
You can also layer other protocols on top of the transport to provide acknowledgement e.g. BTF, AS2. ebXML etc.INPUT:
<keys>
<key>
<name>first</name>
<value>123</value>
</key>
<key>
<name>second</name>
<value>45678</value>
</key>
</keys>XSLT:
<xsl:stylesheet version=\”1.0\” xmlns:xsl=\”http://www.w3.org/1999/XSL/Transform\”><xsl:template match=\”/\”>
<keysout>
<xsl:apply-templates/>
</keysout>
</xsl:template><xsl:template match=\”//key\”>
<xsl:variable name=\”elname\”>
<xsl:value-of select=\”name\”/>
</xsl:variable>
<xsl:element name=\”{$elname}\”>
<xsl:value-of select=\”value\”/>
</xsl:element>
</xsl:template></xsl:stylesheet>
The trick above is making the element name a variable.
OUTPUT:
<keysout>
<first>123</first>
<second>45678</second>
</keysout>I would suggest you write it all in native XSLT. We use Stylus Studio which has an XSLT debugger for all our complex maps. Then in Biztalk, click on the map grid, then set the \”Custom XSLT Path\” property to the name of your .xslt stylesheet. You could also try to use the Scripting functoid and use in-line XSLT.
Neal Walters
http://Biztalk-Training.com<?xml version=’1.0′?>
<xsl:stylesheet version=\”1.0\” xmlns:xsl=\”http://www.w3.org/1999/XSL/Transform\”><xsl:template match=\”/\”>
<xsl:apply-templates/>
</xsl:template><xsl:template match=\”//key\”>
<xsl:variable name=\”elname\”>
<xsl:value-of select=\”name\”/>
</xsl:variable>
<xsl:element name=\”{$elname}\”>
<xsl:value-of select=\”value\”/>
</xsl:element>
</xsl:template></xsl:stylesheet>
Don’t know an example, but here are some steps.
1) Design your flat file schema. Use right-click \”Validate Instance\” until it works with your csv file.
2) You can optionally map your data to a regular XML schema. You will use this XMl in the next step. (If you want to build an simple csv-file-in/xml-file-out orchestration at this point you could. Get something small and easy working, then add to it step by step.)
3) Most likely, your CSV file will contain many records, not just one, correct? You will need to write a stored proc that uses OpenXML. See this blog: http://nealwalters.blogspot.com/2005_12_01_nealwalters_archive.html .
NOTE: There might be an another alternative here, but I have not tried it. You could try to build the updategram insert statements directly, but where I have worked, we always go through stored procs.
4) Run the SQL Adapter to build a schema that represents the input/outputs of your stored proc. Your input parm to the stored proc will be one parm, something like \”xmlin\”. I always like returning a least a success/failure flag from the stored proc so that I can call it syncronously with request/response. In the schema, promote or distinguish your parm to make it easy to set below.
5) Create an orchestration to receive the CSV file, map it to xml, use construct/message assignment shape to set parm, then call stored procedure (Send/Receive from a request/response port).
Neal Walters
http://Biztalk-Training.comP.S. My training videos include an entire CD on the SQL adapter, and also some videos on flat file schemas.
The #if ain’t gonna work!
We have a debug flag in the Biztalk config file
\”c:\\Program Files\\Microsoft BizTalk Server 2004\\BTSNTSvc.exe.config\”.Then do something like this:
blnTraceFlag = System.Convert.ToBoolean(System.Configuration.ConfigurationSettings.AppSettings.Get(\”MyProject.MyOrchName.TraceFlag\”));An if statement like this will work in expression shapes, but unfortunately not Message Assignment shapes.
if(blnTraceFlag == true){
// put your trace logic here.
}
Neal Walters
http://Biztalk-Training.com -
AuthorPosts