<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>Semaphore Media and Development</title>
	<link>http://www.semaphoremd.com</link>
	<description>...at the crossroad of creativity and technology...</description>
	<lastBuildDate>Wed, 23 Nov 2011 18:01:49 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.1.3" -->

	<item>
		<title>deploy Visual Studio database project through TFS 2010 build</title>
		<description><![CDATA[I found a great article on how to configure auto deploy VS database project after build using TFS 2010. http://www.codewrecks.com/blog/index.php/2010/01/04/deploy-a-database-project-with-tfs-build-2010/ One more note: If you want to manually execute the deployment script generated by MSBuild using SQL Mgmt Studio, make sure to set it to SQL Command Mode first or else the :setvar line will [...]]]></description>
		<link>http://www.semaphoremd.com/2011/11/18/deploy-visual-studio-database-project-through-tfs-2010-build/</link>
			</item>
	<item>
		<title>MQSC adapter not available in Biztalk Administration console</title>
		<description><![CDATA[While working on a small POC project using BizTalk 2009, I encountered an issue where MQSC adapter isn&#8217;t showing up in BizTalk Admin Console. By following the steps described in the blog post I was able to fix the issue. http://blog.nimbo.com/biztalk-2009-websphere-mq-communication-on-windows-2008-64-bit/ Apparently the adapter isn&#8217;t getting registered under WOW6432Node in registry. Reinstall WebSphere MQ (client-based) [...]]]></description>
		<link>http://www.semaphoremd.com/2011/11/17/mqsc-adapter-not-available-in-biztalk-administration-console/</link>
			</item>
	<item>
		<title>generating polling statement schema via WCF-Oracle DB adapter</title>
		<description><![CDATA[How to generate a polling statement schema using adapter wizard: 1. in the binding properties tab of wizard, set: InboundOperationType: Polling EnableBizTalkCompatibilityMode: True PolledDataAvailableStatement PollingStatement: 2. Click connect and select &#8220;Service (Inbound Operations)&#8221; 3. Instead of clicking on a schema, click on the top branch i.e &#8220;/&#8221; 4. In the &#8220;Available categories and operations&#8221; box, [...]]]></description>
		<link>http://www.semaphoremd.com/2011/08/02/generating-polling-statement-schema-via-wcf-oracle-db-adapter/</link>
			</item>
	<item>
		<title>Installing 32-bit and 64-bit Oracle 11g R2 ODAC to work with BizTalk 2010 Oracle adapters</title>
		<description><![CDATA[Installing Oracle&#8217;s ODAC drivers can be a struggle since the installation guide, from both Oracle and Microsoft, does not spell out the gotcha&#8217;s. After a few days of testing, we finally got it right. Here are the steps taken to ensure that both versions are supported by BizTalk 2010. 1. Download both 32-bit and 64-bit [...]]]></description>
		<link>http://www.semaphoremd.com/2011/05/03/installing-32-bit-and-64-bit-oracle-11g-r2-odac-to-work-with-biztalk-2010-oracle-adapters/</link>
			</item>
	<item>
		<title>Restoring master secret when migrating BizTalk installation to a new server</title>
		<description><![CDATA[There will be a time when BizTalk databases need to be migrated to a new SQL server i.e. hardware upgrade or configuring a new cluster. Before restoring the SSODB database, the original master secret need to be restored. In a SQL cluster environment, make sure to check off &#8220;Use Network Name for computer name&#8221; option [...]]]></description>
		<link>http://www.semaphoremd.com/2011/01/18/restoring-master-secret-when-migrating-biztalk-installation-to-a-new-server/</link>
			</item>
	<item>
		<title>&quot;the binary code for the script is not found&quot; error</title>
		<description><![CDATA[When working with BAM, if you try to run the BAM_AN_ SSIS package in SQL Server 2008 in order to load the activity data to the cube and get &#8220;the binary code for the script is not found&#8221; error, then it is most likely due to missing SQL Server component. Make sure to install the [...]]]></description>
		<link>http://www.semaphoremd.com/2010/06/16/the-binary-code-for-the-script-is-not-found-error/</link>
			</item>
	<item>
		<title>BizTalk project creation failed</title>
		<description><![CDATA[At some point all BizTalk developer will run into this pesky issue. You try to create a new BizTalk project and you get an &#8220;&#8230; project creation failed&#8221; error in Visual Studio. This is because, perhaps after a VS update or other installation, the &#8220;PossibleProjectExtensions&#8221; attribute in Windows registry get replaced by the default value. [...]]]></description>
		<link>http://www.semaphoremd.com/2010/05/26/biztalk-project-creation-failed/</link>
			</item>
	<item>
		<title>FTP folder permission</title>
		<description><![CDATA[The interface need to first check to see if a folder already exists on FTP server. If not it needs to create the folder first before the FTP adapter sends the message. After spending a day trying all sorts of methods, I finalized on the following approach: 1. create a helper class that establish a [...]]]></description>
		<link>http://www.semaphoremd.com/2010/05/07/ftp-folder-permission/</link>
			</item>
	<item>
		<title>update/delete operation DB2 table</title>
		<description><![CDATA[When selecting a recordset for update or delete from a DB2 table using the DB2 adapter, you may run into the following error when attempting to execute the update/delete statement: &#8221; &#60;DB2 table&#62; ?&#60;DB2 schema&#62; ?3 in *N not valid for operation.&#8221; This is because the table is not journaled and that DB2 adapter expects [...]]]></description>
		<link>http://www.semaphoremd.com/2010/03/05/updatedelete-operation-db2-table/</link>
			</item>
	<item>
		<title>Persisting AS2 message file name and file name-based message routing</title>
		<description><![CDATA[My client has a new requirement that calls for saving the inbound AS2-based message in it&#8217;s original file name, and that the file must be saved to a specified file folder if the inbound file name&#8217;s first 14 characters matches a string pattern. Reading this post http://blogs.msdn.com/biztalkb2b/archive/2009/08/05/as2-filename-preservation.aspx it implies that the AS2Receive pipeline component should [...]]]></description>
		<link>http://www.semaphoremd.com/2010/02/12/persisting-as2-message-file-name-and-file-name-based-message-routing/</link>
			</item>
</channel>
</rss>

