I was working with a customer recently where they do not want to install SSIS on the SQL Server hosting BizTalk databases, instead the requirement was to have a separate server dedicated to SSIS which will run the BAM packages. At the first instinct, it seemed like that this is not possible and we need...

Recently, I worked on a BAM issue and I wanted to share with you all some interesting facts which I found while researching on this. Customer implemented BAM Activities with Event Streams. They were using OrchestrationEventStreams within Orchestrations. This is how their flow looks like in short: Orch1...

Ever wondered why the BAM SSIS packages for archiving (BAM_DM_<activity_name>) is not archiving the data from BAMPrimaryImport DB to BAMArchive DB though we see that the package executes successfully. Ok. This may be the reason. The BAM SSIS packages for archiving (BAM_DM_<ActivityName>)...