BAM Archive Job in BizTalk 2020

Question

Since in BizTalk 2020 version, BAM packages have moved to SSISDB from MSDB (as it was in previous versions), the old BAMArchive job is not working. Is there any SSIS package or any other SQL job to execute all BAM activities' packages together?

Answer 1

Hi There,

Thank you for asking this question on the Microsoft Q&A Platform.

Did you tried the solution implemented by Sandro in below article, please check if this can help you.

https://blog.sandro-pereira.com/2021/10/21/biztalk-server-2020-bam-configuration-microsoft-sql-server-integration-services-ssis-is-not-installed-on-the-local-machine/

Regards,
Kamlesh Kumar
BizTalk Techie

If this answer solved your problem, please click the Verify Answer button (found below the answer) to help other users who have the same question.