Hi @Wayne ,
Please use try, catch to get the detailed error messages .
Hope the following links will be helpful:
- TRY...CATCH (Transact-SQL)
- Deploy an SSIS project from SSMS with Transact-SQL
- Deploy Integration Services (SSIS) Projects and Packages
- Tutorial: Deploy and run a SQL Server Integration Services (SSIS) package in Azure
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Hot issues in October--Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet.