Hi @Foster Holt ,
As far as I known, VS2019 could not set the target to SQL Server 2022.
VS 2022 support is one major item that SSIS team is working on, current outlook is before end of this year.
So I think that you could not use SQL Agent Job to run package in SQL Server2022.
Details you may refer to SQL Server Integration Services Projects Q&A
Regards,
Zoe
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.