Hi @Greg Booth ,
Welcome to Microsoft Q&A!
Visual Studio 2022 Community provide core SQL Server Data Tools functionality. But in your situation, I recommend you use the Professional or Enterprise editions.
For SSDT, it has been integrated into Visual Studio 2022.
You can install it as individual component in Visual Studio Installer > Modify.
For Integration Services (SSIS) and Reporting Services (SSRS) projects, you need to install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.
For more information, please visit: Download SSDT for Visual Studio.
Sincerely,
Anna
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.