解决方案:
URL: Visual Studio 2019 16.9.0 SSIS Script Task - VSTA Wont Load - Microsoft Q&A
VSTA download URL: Download Microsoft Visual Studio Tools for Applications 2019 from Official Microsoft Download Center