BAM SSIS package BAM_DM_<activity_name> not archiving data

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>) are a two step process. They handle partitioning and archiving. During each run,…


KB Article on maintenance of Biztalk databases

Yesterday, KB 952555 got published which talks about how to maintain and troubleshoot Biztalk Server databases. This is a very useful article and must to be followed if you want Biztalk to be in good shape specially if performance is a key factor. Thank you, Mandi, for writing this wonderful article.

Most Common Issue – Slow Processing due to huge Biztalk databases

I have seen most of the issues coming with slow processing of messages in production by Biztalk where the root cause is only due to large size of Biztalk databases. Though, Biztalk comes with SQL Jobs which maintains the Biztalk databases and keep them at good shape, but if these Jobs are not configured properly or…