Learn, Troubleshoot BizTalk with Ashok Rajpurohit

•          The Biztalk engine has the notion of publishing system level (positive) Acknowledgments ( ACK’s ) which indicate a successful message transmission and Negative Acknowledgments ( NACK’s ) which indicate the suspension of a message. •          Orchestrations can use delivery notification to subscribe to these acknowledgments for the messages that they send •          These are extremely powerful and can be used for handling the outcomes of asynchronous operations in the engine. •          For example, consider the scenario whereby an Orchestration transmits a one-way message over HTTP, the Orchestration will publish the message to the Message Box which will route it to the appropriate send port. The transmission of the message is completely decoupled from the Orchestration publishing to the Message Box, so the Orchestration has no notion of whether the transmission actually succeeded or not, instead the Orchestration only knows whether the message was successfully publish

Create a new port on orchestration port surface, Define the name of port Port Type Define Port Binding                                                                i.       Port direction communication: select “I will be sending message on this port”                                                              ii.       Port Binding : “Dynamic”                                                             iii.       Send Pipeline : “Passthrough/XML Transmit” Click next and   Finish. Add Expression shape to the Orchestration. Then you can define the address and other properties of   Dynamic Port as show below. DynamicPortOut(Microsoft.XLANGs.BaseTypes.Address) = "net.tcp://localhost:8001/netTcp"; DynamicPortOut(Microsoft.XLANGs.BaseTypes.TransportType) = "WCF-NetTcp"; The address could be anything like Folder Location/Http URI/Service URI/ SQMQ 3. Now you can test your Dynamic Port created.

MultiPart Message : is Message with multipart part in it. Example we can have one message input to “Receive Shape” of orchestration and which indeed has multiple message. Here we have InputMsg as multipart message.It’s Message Type is “ MulitpartMsg.MutipartType_1”. Which has three types of message (Num1, Num2, Num3) in it all are defined as type int.The int type is for this sample only you can define it as any DataType or schema.     The receive shape (Receive_1) has message “InputMsg” which is of type Multi-Part message types. Then I published this Orchestration as Web service using “BizTalk Web Publishing Wizard”.The Published WebService when opened in Browser.Shows Multipart-Message as input parameter to method “Operation_1” Then I have created a test application to test my Webservice. I added web service as web reference to my application & then called method Operation_1 (Num1, Num2, Num3) and passed multipart message parameter value and got the desired output. //Creat

1.                   Download AdventureWorksDB file from Microsoft link http://msftdbprodsamples.codeplex.com/releases/view/4004 2.                   run and install   the .MSI file on your system , Make sure after installing AdventureWorkDB the following files exists in folder location “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” a.        AdventureWorks_Data.mdf b.       AdventureWorks_Log.ldf 3.                   Once the installation is completed then we need to attach AdventureWorksDB to SQL server. a.        Right Click on Database,Click Attach  b.       On Attach database screen,click Add c.        On Locate database file, Go to folder location “ C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data ” and select “AdventureWorks_Data.mdf” file.Click Ok. d.       And your AdventureWorksDB added successfully.

Formatting the Data View The default data view that we are presented with uses uninspiring black serif text on a white background. We can jazz up our data view using two different methods: Direct Formatting It is possible to apply formatting directly to our data view by highlighting the cells that we wish to format and then using the formatting tools. This can be a good option if we only want to format a single data view but is not the best approach if we would like to apply our formatting on a site-wide basis. CSS Formatting A more manageable way to apply formatting to our data views is to make the changes across the entire site by editing our style sheet. When we click in the cell that has the Price heading in it, notice that a tag appears above it, telling us that this cell is referred to as th.ms-vh. That is to say that it is a table heading (th) element that is being rendered using the ms-vh class (which I assume stands for Microsoft View Heading). Similarly, if we click in