Show Pipeline Custom Component in Visual Studio ToolBox

Show Pipeline Custom Component in Visual Studio ToolBox

Add the below code in the Project Build Events

"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\GacUtil.exe" /i "$(TargetPath)" /f
xcopy "$(TargetPath)" "C:\Program Files (x86)\Microsoft BizTalk Server 2010\Pipeline Components" /d /y

Avoid Empty Nodes Using Table Looping Functoid in BizTalk

Avoid Empty Nodes Using Table Looping Functoid in BizTalk

You will find out lot of several posts to avoid empty nodes using Table Looping Functoid
My Flat Source File looks like this

SID

Name

Title

Sub1

Sub1Fee

Sub2

Sub2Fee

Sub3

Sub3Fee

Sub4

Sub4Fee

Sub5

Sub5Fee

Remark

1

ABCD

SW

A

12.50

None

2

BCDE

DBA

B

13.50

C

15.00

Completed

Flat file converted to the XML (StudentIn.xml) using pipeline components

Mapping

File Lock Error In Visual Studio

Your project dll is referenced by another project, when you trying to build a project, you will get file lock issue in visual studio,

Unable to copy file "obj\Debug\BizTalk.MSDynamicsCRM2011.Schemas.dll" to "bin\BizTalk.MSDynamicsCRM2011.Schemas.dll". The process cannot access the file 'bin\BizTalk.MSDynamicsCRM2011.Schemas.dll' because it is being used by another process.

if exist "$(TargetPath).locked" del "$(TargetPath).locked"
if exist "$(TargetPath)" if not exist "$(TargetPath).locked" move "$(TargetPath)" "$(TargetPath).locked"

if exist "$(ProjectDir)bin\$(TargetFileName).locked" del "$(ProjectDir)bin\$(TargetFileName).locked"
if exist "$(ProjectDir)bin\$(TargetFileName)" if not exist "$(ProjectDir)bin\$(TargetFileName).locked" move "$(ProjectDir)bin\$(TargetFileName)" "$(ProjectDir)bin\$(TargetFileName).locked"

Register dll in 'C:\Windows\Microsoft.NET\assembly\GAC_MSIL'

"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\GacUtil.exe" /i "$(TargetPath)" /f

Retrieve Multiple Dynamics CRM 2011 Entity Records from BizTalk 2010 Server

Retrieve Multiple Dynamics CRM 2011 Entity Records from BizTalk 2010 Server
1)Create new map (MCRM_List.btm)

2) Added <Fetch><Query/></Fetch> schema in the SAuditXML.xml schema

3)Select Source Schema (SAuditXML), Desitnation Schema(DNS_BTS_CRM.organixationservice_schemas_microsoft_com_xrm_2011_contracts_services -> RetrieveMultiple)

4)Make Query(source) link to FetchExpression->Query(Destination)

Create/Update/Delete Dynamics CRM 2011 Entity Record from BizTalk 2010 Server

Create Dynamics CRM 2011 Entity Record from BizTalk 2010 Server

1)Create new map (MCRM_Create.btm)

2)Select Source Schema (SAuditXML), Desitnation Schema(DNS_BTS_CRM.organixationservice_schemas_microsoft_com_xrm_2011_contracts_services -> Create)

3)Rename Page name (Enity), make EnityName(source) link to LogicalName(Destination)

Dynamics CRM 2011 and BizTalk 2010 Server Integration - Exception

Exception 1
The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://schemas.microsoft.com/xrm/2011/Contracts/Services:entity. The InnerException message was 'There was an error deserializing the object of type Microsoft.Xrm.Sdk.Entity. End element 'value' from namespace 'http://schemas.datacontract.org/2004/07/System.Collections.Generic' expected. Found element 'Value' from namespace 'http://schemas.microsoft.com/xrm/2011/Contracts'. Line 1, position 4190.'. Please see InnerException for more details.

Solution
Data Type is wrong.

For example, In CRM attribute type is int, but in BizTalk Schema contains string and in the Map, Script Functionid contains <xsl:attribute name="xsi:type"><xsl:value-of select="'xs:string'" /> , the CRM will throw the above error.

Change to  int in the schema and <xsl:attribute name="xsi:type"><xsl:value-of select="'xs:int'" /> in the Map

Dynamics CRM 2011 and BizTalk 2010 Server Integration - Handling Fault Exception

Dynamics CRM 2011 and BizTalk 2010 Server Integration - Handling Fault Exception

1)Refer the previous blog Querying Dynamics CRM 2011 Entrity Record from BizTalk 2010 Server

 
2)Right click the project -> Select Add -> New Item ->  Schema (SFault.xsd) -> Press 'Add' button

Select Dynamics CRM 2011 Entity Record from BizTalk 2010 Server

Dynamics CRM 2011 BizTalk 2010 Server Integration - Select Dynamics CRM 2011 Entity Record from BizTalk 2010 Server

Step 1 - Create Schema and Orchestration

1)Import Dynamics CRM 2011 Organization Service SOAP Protocol to BizTalk Server 2010
   Create New Project (CRMORGSOAP.dll) and add refernece to this project.

2)Right click the project -> Signing -> Check 'Sign the assembly' -> Create <New> 'Strong Name     Key' or <Browse> existing one
  Select Deployment -> Enter Application Name ('DNS_BTS_CRM') -> Restart Host Instances - True
 
3)Right click the project -> Select Add -> New Item ->  Schema (SAudit.xsd) -> Press 'Add' button
  <Select> used for pass entity name and record id to CRM.
  <List> used for response result from CRM.
 

Import Dynamics CRM 2011 Organization Service SOAP Protocol into BizTalk Server 2010

Import Dynamics CRM 2011 Organization Service SOAP Protocol to BizTalk Server 2010

1)Open Visual Studio 2010, Select File menu -> New -> Project -> 'Empty BizTalk Server Project'

2)Right click the project, Select Add menu -> 'Add Generated Items...'
 
3)Select 'Consume WCF Service', press 'Add' button

BizTalk

BizTalk Server is an enterprise service bus (ESB) that can connect/communicate to various business servers. Biztalk is MS Integration and connectivity server solution. It provides the following functions: Enterprise Application Integration, Business Process Automation, Business-To-Business Communication, Message broker, and Business Activity Monitoring. BizTalk connects diverse system.