Monthly Archives: October 2011

SSIS Attunity Connectors

Recently I had to create an SSIS package that transferred a huge amount of data between an Oracle database and a MS SQL Server database. I began creating an SSIS package that used an existing linked server connection that the client had already been using to perform similar data transfers. To my dismay, the performance of the linked server was dismal. Instead of using the linked server I decided to go with the OOTB OLE DB data source available in SSIS. This increased my performance dramatically. However, when I spoke to a colleague at TCSC, he recommended that I try the Microsoft Connectors for Oracle by Attunity. I had never heard of these connectors, but I was intrigued, so I downloaded them and ran some performance test. The following tests results we recorded while debugging through Visual Studio, so real numbers will be better than what I have recorded, but the results do represent without a doubt the performance differences between the different connections.

Posted in Business Intelligence, SSIS | Tagged , , | Leave a comment

BizTalk 2010 Exception: An error occurred when decrypting an AS2 message

After setting up a new BizTalk 2010 server at a client site, we immediately began getting these errors when trying to decrypt and validate messages coming from our trading partners. The fix for us was to not only make sure that the server certificates were in all the proper stores according to the Microsoft chart, but we also needed one additional location set:

Posted in BizTalk 2010 | Leave a comment

Microsoft SharePoint Conference 2011 Review

We are fresh off the conclusion of the Microsoft SharePoint Conference 2011 in Anaheim, CA and it was fantastic! The conference provided us with several insights, but most noteworthy that SharePoint is growing, and growing rapidly! You could see this everywhere, in the amount of attendee turn out (~7,500), the number of sponsors and sessions, the worldwide diversity of attendees, and the amount of social gatherings every night. We knew going into it that because it was a mid-production cycle conference that no major news would probably be announced and that was immediately evident in the keynote remarks regarding how this year’s theme was productivity. This was featured in many of the session topics, whether it was business automation using composite solutions, FAST, or being more efficient with the cloud.

Posted in SharePoint Conference | Tagged , | 2 Comments

Sitecore Layouts and Code Blocks

One problem I recently ran into is that you cannot put ASP.NET code blocks in a Sitecore Layout.  The page will work perfectly fine in Content Editor and on the live site, but if you try to use Preview or Page Editor, you will see something like this:

Posted in .Net, Development, Sitecore | Leave a comment

SharePoint 2010: BCS w/o GAC

This article describes how to use SharePoint 2010′s Business Connectivity Services without putting any assemblies in the Global Assembly Cache (GAC).

 

Posted in Uncategorized | Leave a comment