Sandro PereiraABOUT ME:
My name is Sandro Pereira and I live in Oporto – Portugal. I work as a consultant at DevScope. My main focus is on Integration Technologies where I’ve been using .Net, Microsoft BizTalk Server and SOAP/XML/XSLT since 2002. I’m an active blogger and a participant on the MSDN BizTalk Server Forums.

I’ve experience in almost all BizTalk versions: 2004, 2006, 2006 R2, 2009, 2010 and migration of projects of 2002. In the last few years I have been working on Cloud Provisioning at a major telecommunications service provider here in Portugal.

I’m  an active member and moderator on the MSDN BizTalk Server Forums, Code Gallery contributor and was awarded Most Valuable Professional (MVP) for BizTalk Server by Microsoft since 2011. I’m also member of theBizTalkBrazil community: http://www.biztalkbrasil.com.br/, member of BizTalk Administrators community: http://www.biztalkadminsblogging.com and member of NetPonto community: http://netponto.org/.

My email address: sandro-pereira@live.com.pt, feel free to contact me or leave a comment to a post on this blog.


This blog is a place for me to write and share useful notes about BizTalk Server, .Net, tools, links, articles, sample code and experiences that are related to my work, hoping to be interesting for some.


Awarded as a Microsoft® Most Valuable Professional (MVP), Microsoft Integration for 1/1/2015 – 1/1/2016
Awarded as a Microsoft® Most Valuable Professional (MVP), Microsoft Integration for 1/1/2014 – 1/1/2015
Awarded as a Microsoft® Most Valuable Professional (MVP), Microsoft Integration for 1/1/2013 – 1/1/2014
Awarded as a Microsoft® Most Valuable Professional (MVP), BizTalk for 1/1/2012 – 1/1/2013
Awarded as a Microsoft® Most Valuable Professional (MVP), BizTalk for 1/1/2011 – 1/1/2012



MCTS Sandro Pereira Logo

Sandro Pereira MCTS Logo

Microsoft® Certified Technology Specialist  (MCTS)


Microsoft Biztalk Server 2010

Achievement Date:



Biztalk® Server 2006, Custom


Achievement Date:


View my official MCP transcript on the Microsoft Learning site and my MCP Profile

Other Certifications:

  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2010)
  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2012)
  • Microsoft Partner Network BizTalk Technical Competency Assessment for Application Integration (2013)
  • Microsoft Partner Network Sales and Marketing Competency Assessment for Application Integration (2014)


Rua Passos Manuel, 223 – 4º Floor
4000-385 Oporto Portugal



Member and co-founder of the BizTalk Crew, that are responsible for organize BizTalk Innovation Events accross all Europe, along with Nino Crudele (Microsoft Integration MVP from Italy), Saravana Kumar (Microsoft Integration MVP from UK), Steef-Jan Wiggers (Microsoft Integration MVP from Nederland) and Tord Glad Nordahl (Microsoft Integration MVP from Norway).

Sandro Pereira Public Speaker

Book Author:

BizTalk Mapping Patterns and Best Practices” book author.

The BizTalk Mapping Patterns and Best Practices book is a reference guide mainly intended for BizTalk developers to make their day-to-day lives easier. A 400-page recipe for BizTalk Developers to develop effective, robust, and organized maps. The book offers insights on how maps work, the most common patterns in real time scenarios, and the best practices to carry out transformations. Click here to download your free copy of the eBook.



The views and opinions stated in this blog are mine and do not necessarily reflect those of my employer. Each posting on this blog is provided “AS IS” with no warranties, and confers no rights.



Date of Certification/ Membership

Description: Certification Logo Image

Biztalk® Server 2006, Custom Applications


  1. Gisis says:

    I have encountered the following situation.Would appreciate your insights.

    Case description:

    1.We are using BTS 2010 (w/Adapter pack 2010) to post IDoc messages into SAP (ECC 6, EHP 5).
    2.My scenario is a plain FTP to SAP.
    3.I used the WCF-SAP Adapter with a strongly typed Schema and a Send operation.
    4.We have created a Target Schema representing a multi IDoc structure in order to handle a 1: n scenario (using the maxOccurs setting originally set to 2147483647 available in Adapter pack 2010)
    5.When a single message with multi-line arrives we need to generate a single IDoc message of each line. (Control record +1 line of payload)
    Currently the result IDoc is not what we expect:

    We get “N” Idocs (according to the amount of kines in the source files) and the payload is replicated to each IDoc.(not spilted to single record per IDoc.

    Attached is the XML as picked up from the Msg. Box by the Adapter just before posting theIDoc to SAP.

  2. Shah M. says:

    Hello Sandro,

    I have an orchestration which under high load is waiting a few minutes between its initialization and its receive shape. The receive shape activates the orchestration by receiving a message from the message box. Do you have any idea as to why BizTalk is delaying the reception of the message ?

    According to you which BizTalk settings need to be monitored / configured to resolve my problem ?

    Thanks you in advance for your reply.

    Kind regards,

  3. Hi
    it’s available the BizTalk 2013 Developer Immersion Training Kit? Do you know it’s possible download? Thanks in advance

  4. Henrik Jensen says:

    I have a question in relation to encryption protocol support in the latest BT2013R2. I have not been succesfull in getting an official confirmation that SHA256 is supported in BTS2013 pipelines?
    Can you maybe assist?


    • Hi Henrik, never try it but it seems that BizTalk supports SHA256
      I think this type of configuration are not made in pipelines, instead you need to use the Security tab in the Transport Properties of the WCF Adapter and use
      Basic128Sha256: Use Aes256 for message encryption, Sha256 for message digest, and Rsa-oaep-mgf1p for key wrap
      Basic128Sha256Rsa15: Use Aes128 for message encryption, Sha256 for message digest, and Rsa15 for key wrap.
      Or other, there are several SHA256 algorithms
      Check the following url: https://msdn.microsoft.com/en-us/library/jj572855.aspx

  5. […] learn more about how to register the BHM MMC with BizTalk MMC. I would also recommend the post by Sandro Pereira where has very well explained Installing the new BizTalk Health Monitor snap-in on Biztalk Server […]

  6. Praveen Kumar says:

    Hi Sandro,

    I have encountered the following situation.Would appreciate your insights.

    Case details:

    File transport does not have read/write privileges for receive location in BizTalk 2010:

    It is happening for Receive & Send Folder locations. I’m unable to enable the send & receive locations.

    1. I’ve gave full access control to the shared folder location
    2. I can open the shared folder location in Internet folder
    3. I’ve tried to give local D drive folder access also. It is having the same issue as below:


    The Messaging Engine failed to add a receive location “ReceiveCsvFromSourceSystem_File” with URL “\\sportshub.com.sg\biztalk\BISFileShare\POLL\SalesTransaction\From_POS\*.csv” to the adapter “FILE”. Reason: “File transport does not have read/write privileges for receive location “\\sportshub.com.sg\biztalk\BISFileShare\POLL\SalesTransaction\From_POS\”. “.

    Please help me to fix this ASAP.

    Praveen Kumar A.R

  7. Iurii says:

    Hi Sandro,

    I need to migrate existing Biztalk 2006R2 environment running on windows 2003×32 to BT2013(guess through BT2010). I saw a guide from MS, however it is not applicable in my case, as I have old hardware and in place upgrade is not applicable.
    In Google I haven’t found any clear guidance on how to migrate all information from existing setup. Maybe you have link to this information?

    • Hi Iurri,
      I never made an upgrade to a BizTalk environment because I found that not useful, instead I prefere to create a new environment and migrate de solutions to this new environment, there are far fewer risks by doing that.

      The problem in upgrade de env is that you also need to upgrade the SQL and the SO:
      BTS 2006R2 supports: Windows Server 2003 with Service Pack 1 (SP1) or Service Pack 2 (SP2), or Windows Server 2003 R2 — SQL Server™ 2005 with Service Pack 2 or SQL Server 2000 with Service Pack 4

      BTS2010 only supports: Windows Server 2008 R2, Windows Server 2008 R2 SP1, Windows Server 2008 SP2 — SQL Server 2008 R2 SP1/SQL Server 2008 R2/2008 SP1

      So if you want to do that probably you need to upgrade to BTS2009, update SO and SQL, than update to 2010 and upgrade SO and SQL, something like that and is for this reason that I never do this type of task and prefer to advice to create a new env.

      • Iurii says:

        Thanks for fast reply! Actually I was talking about move settings from old to new environment. However I don’t know on how to move all settings and data from exisitng databases, especially when it is about BT failover cluster. BAM portal settings and so on…Move SSO server..

  8. Aj Singh says:

    Hi Sandro,

    Request you to please share a page/blog, which guides us all for a conversion of a flat file to X12(EDI 837I/P/D) format. I am new to Biztalk, have done research on it, but couldn’t successfully achieve the expected results so far.

    Really looking forward to for your reply, thanks in advance


  9. Shah MOHAMOD says:

    Hi Sandro,

    According to you which of the following solutions will perform better:
    1. Mapping in c# code
    2. BizTalk Mapper

    Assumption: the data to be mapped is of fair size

    Thanks for your reply

  10. Rafael Mora says:

    Hi Sandro

    I have a question, is about de message queues, i have a problem when i restart de host instance some messages are resending, but i not need this, how are stop this resend, the message are in queue becouse the WebService have a timeout.

    You have a consultant modalitiy? i’m from Costa Rica

    I apreciate your time to answer me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Get every new post delivered to your Inbox.

Join 376 other followers

%d bloggers like this: