I'm wondering if someone may be able to point me in the right direction here as after looking at this I've not made much progress.
The situation is I have a Visual Studio 2019 solution and within it is a SSIS project (I should say they were originally done in VS 2015 for SQL 2012 but have been upgrade by VS 2019 without issue) , within that are 2 SSIS packages, I'm trying via VS 2019 to deploy these to a SQL 2019 server (with SSIS on it). The packages all run fine, build so I right click the project (SSIS) and select deploy. I then get asked to pick the server, which I do and the path is set (SSISDB/folder/function. I then hit deploy.
I then get green ticks for (loading project, connecting to destination server and changing protection level) but then after about 10 seconds I get a failure on the final deploying project task. I've attached the failure to this post.
I did some research and it seems some users had this but they solved it with a reboot, I've rebooted and still get the same.
The error also states
Failed to deploy project. For more information, query the operation_messages view for the operation identifier '7'.
But when I look at catalog.operation_messages there are no entries.
Does anyone have any thoughts or ideas.
- This topic was modified 2 years, 6 months ago by NicHopper. Reason: added file