Hi There,
Thank you for asking this question on the Microsoft Q&A Platform.
This issue has been discussed and resolved in below thread, And yes you have to install the SSIS on BizTalk and SQL server.
https://learn.microsoft.com/en-us/answers/questions/286628/bam-configuration-error-biztalk-2020.html
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.