BugLoSE will host second meeting

The first meeting was a success. Not as good as BUGS I can tell you that, but the feedback had a lot of nice words in it at least.

Next Thursday is Holy Thursday, which by Swedish work ethic means that no one attends a meeting after 12. Therefore the meeting is held next Thursday (the 12th) at the same time.

The topic is: A lot of useful hints and tricks that are in BizTalk but that you might know of or seldom use.

Blog Post by: Mikael Sand

SQL Server 2012 RTM: installing SSDT | installation des SSDT

On my development machine, I wanted to install the SQL Server Data Tools. With Visual Studio 2010 and SQL Server 2012 RTM installed, the SSDT are still to be installed from here : Sur ma machine de d%u00e9veloppement, je voulais installer les outils de donn%u00e9es SQL Server (SSDT). Avec Visual Studio 2010 et SQL Server 2012 RTM install%u00e9s, les SSDT restent %u00e0 installer depuis ici :

http://msdn.microsoft.com/en-us/data/hh297027

From Windows Platform Installer (WebPI), it failed, so I went to the bottom of this same installation page where there is the possibility to download SSDTSetup.exe. After executing this setup in an interactive way, I got the error message: Depuis Windows Platform Installer (WebPI), cela ne fonctionnait pas; je suis donc all%u00e9 en bas de la page d’installation o%u00f9 il y a la possibilit%u00e9 de t%u00e9l%u00e9charger SSDTSetup.exe. Apr%u00e8s l’avoir ex%u00e9cut%u00e9, j’ai eu le message d’erreur suivant:

—————————
Microsoft SQL Server Data Tools
—————————
Another version of this product is already installed. Installation of this version cannot continue. To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel.
—————————
OK  
—————————

and the log file contained: et le fichier journal contenait:

[19B0:19B4][2012-03-27T16:53:31]: Burn v3.6.2019.0, path: C:\afac\SSDTSetup.exe, cmdline: ‘-burn.unelevated BurnPipe.{6A283163-FBB4-4D58-A2FA-589771413B38} {8CB390BD-E4D0-42B0-95B6-707B31E19B86} 6536’
[19B0:19B4][2012-03-27T16:53:31]: Initializing numeric variable ‘InstallLanguage’ to value ‘1033’
[19B0:19B4][2012-03-27T16:53:31]: Setting string variable ‘WixBundleName’ to value ‘Microsoft SQL Server Data Tools’
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘WixBundleLog’ to value ‘C:\Users\bengui\AppData\Local\Temp\2\sql_SSDT_1000_20120327165332.log’
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘WixBundleOriginalSource’ to value ‘C:\afac\SSDTSetup.exe’
[19B0:19B4][2012-03-27T16:53:32]: Detect 24 packages
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘dotnetfx4setupexe_x64_DetectKey’ to value ‘4.0.30319’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘dotnetfx4setupexe_x64_DetectKeyExists’ to value 1
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘dotnetfx4setupexe_x86_DetectKey’ to value ‘4.0.30319’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘dotnetfx4setupexe_x86_DetectKeyExists’ to value 1
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘intShellInstall_DetectKey’ to value ‘1’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘KB2468871V2_DetectKeyExists’ to value 1
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘KB2544514_DetectKeyExists’ to value 1
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘localDBInstall_x64_DetectKeyExists’ to value 0
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11E.LOCALDB’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘localDBInstall_x86_DetectKeyExists’ to value 0
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\’
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\procore\1033’
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘RegSearch_SSDTCTP3Exists’ to value ‘10.1.10712.0’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘vs2010sp1Install_DetectKeyExists’ to value 1
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\’
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\DevDiv\vs\Servicing\10.0\vstdcore\1033’
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘vstscore_DetectKey’ to value ‘1’
[19B0:19B4][2012-03-27T16:53:32]: Setting string variable ‘vstscore1033_DetectKey’ to value ‘1’
[19B0:19B4][2012-03-27T16:53:32]: Registry key not found. Key = ‘SOFTWARE\Microsoft\IIS Extensions\MSDeploy\3’
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘WebDeployV3_DetectKeyExists’ to value 0
[19B0:19B4][2012-03-27T16:53:32]: Setting numeric variable ‘BootstrapperAction’ to value 4
[19B0:19B4][2012-03-27T16:53:32]: Condition ‘((1 <> 1) OR ((vstscore1033_DetectKey = 1)) OR ((vstdcore1033_DetectKey = 1)) OR ((procore1033_DetectKey = 1)) OR ((NOT((1 <> 1) OR ( (vstscore_DetectKey = 1)) OR ( (vstdcore_DetectKey = 1)) OR ( (procore_DetectKey = 1))))))’ evaluates to true.
[19B0:19B4][2012-03-27T16:53:32]: Condition ‘(NOT(RegSearch_SSDTCTP3Exists = v10.1.10712.0))’ evaluates to false.
[19B0:19B4][2012-03-27T16:53:32]: Error 0x80070666: Another version of this product is already installed. Installation of this version cannot continue. To configure or remove the existing version of this product, use Add/Remove Programs on the Control Panel.
[19B0:19B4][2012-03-27T16:53:33]: Error 0x80070666: cannot continue install due to BAL condition.
[19B0:19B4][2012-03-27T16:53:33]: Error 0x80070643: UX aborted detect package begin.
[19B0:19B4][2012-03-27T16:53:33]: Comparing bundle tags: SSDT 10.3.20225.0 1033 {ACC007DE-6558-46E4-A0A0-F76A2E10DA06} —
[19B0:19B4][2012-03-27T16:53:33]: Detect complete, result: 0x80070643

I couldn’t find information with the error message. I searched manually and found this page which provides a script (and a way to execute it) that removes project codename Juneau CTP3.
Here is the magic URL:
En cherchant sur le message d’erreur, je n’ai pas trouv%u00e9 d’information. J’ai cherch%u00e9 ensuite plus manuellement et ai trouv%u00e9 cette page qui fournit un script (et un moyen de l’ex%u00e9cuter) qui supprime l’ancienne version CTP3 qui avait le nom de code Juneau.
Voici l’URL magique:

http://blogs.msdn.com/b/ssdt/archive/2011/11/21/uninstalling-ssdt-ctp3-code-named-juneau.aspx

More context is available here: Plus de contexte est disponible ici

http://blogs.msdn.com/b/ssdt/archive/2012/03/12/ssdt-rtw-supports-in-place-upgrade.aspx

NB: Be aware that uninstallation script may reboot your machine without prompting you Attention: le script de d%u00e9sinstallation peut red%u00e9marrer la machine sans avertissement pr%u00e9alable

 

After that, SSDTSetup.exe can install: Apr%u00e8s cela, SSDTSetup.exe peut installer:

Then you get the tools: Puis on dispose des outils:

 

Benjamin

Blog Post by: Benjamin GUINEBERTIERE

ETL in the Cloud with Informatica: Part 4 – Sending Salesforce.com Data to Local Database

ETL in the Cloud with Informatica: Part 4 – Sending Salesforce.com Data to Local Database

The Informatica Cloud is an integration-as-a-service platform for designing and executing Extract-Transform-Load (ETL) tasks. This is the fourth and final post in a blog series that looked a few realistic usage scenarios for this platform. In this post, I’ll show you how you can send real-time data changes from Salesforce.com to a local SQL Server […]
Blog Post by: Richard Seroter

ETL in the Cloud with Informatica: Part 3 – Sending Dynamics CRM Online Data to Local Database

ETL in the Cloud with Informatica: Part 3 – Sending Dynamics CRM Online Data to Local Database

In Part 1 and Part 2 of this series, I’ve taken a look at doing Extract-Transform-Load (ETL) operations using the Informatica Cloud. This platform looks like a great choice for bulk movement of data between cloud or on-premises systems. So far we’ve seen how to move data from on-premises to the cloud, and then between […]
Blog Post by: Richard Seroter

ETL in the Cloud with Informatica: Part 2 – Sending Salesforce.com Data to Dynamics CRM Online

ETL in the Cloud with Informatica: Part 2 – Sending Salesforce.com Data to Dynamics CRM Online

In my last post, we saw how the Informatica Cloud lets you create bulk data load (i.e. ETL) tasks using a web-based designer and uses a lightweight local machine agent to facilitate the data exchange. In this post, I’ll show you how to transfer data from Salesforce.com to Dynamics CRM Online using the Informatica Cloud. […]
Blog Post by: Richard Seroter

ETL in the Cloud with Informatica: Part 1 – Sending File Data to Dynamics CRM Online

ETL in the Cloud with Informatica: Part 1 – Sending File Data to Dynamics CRM Online

The more software systems that we deploy to cloud environments, the greater the need will be to have an efficient integration strategy. Integration through messaging is possible through something like an on-premises integration server, or via a variety of cloud tools such as queues hosted in AWS or something like the Windows Azure Service Bus […]
Blog Post by: Richard Seroter

BizTalk Server 2010 Cookbook

I love this concept of cookbooks; they follow the same concept as your kitchen cookbook, bunch of recipes to prepare a fancy meal.

You are never going to sit and read all the recipes in one night, you are going to keep the book as reference and follow the recipe you fancy.

Technical cookbook got similar characteristics. There are various recipes, you pick the one that’s more relevant to the piece of work you are doing. Short, Sweet and up to the point.

This new cookbook from Steef-Jan Wiggers consist of over 50+ BizTalk recipes, covering various proven design patterns, best practices, or simply showing you some tips and tricks you never come across.

I personally know Steef-Jan very well and know about this book project for a long time. In fact I was chosen as one of the technical reviewers for the book, but had to pull out due to my commitments with BizTalk360.

Writing a book is not a easy task, most of these guys don’t do it for making money. It’s their passion and interest in technology that drives them to write such valuable books sacrificing  a great deal on their personal life.

With the effort that’s gone into this book by Steef-Jan over the last year or so, I’m fairly confident it’s worth every penny.

EDI Schemas – Beware of special characters which MUST not count towards maximum length restrictions

EDI Schemas – Beware of special characters which MUST not count towards maximum length restrictions

While working on a BizTalk project that required the exchanging of EDI messages with external partners, I came across a situation whereby the partner’s EDIFact messages contained data elements which exceeded the maximum lengths as dictated by their Message Implementation Guide (MIG), which also happened to be the default maximum length in the out of […]
Blog Post by: Johann