Recently while deploying an SSIS ISPAC (developed on my local machine) on to server (Win2012)
I encountered the following error on the SSIS deployment wizard:
And after little head scratching I found the resolution out to be as follows:
ALTER DATABASE SSISDB SET TRUSTWORTHY ON;
And voila, all green on my SSIS deployment wizard…
To read more about the database “Trustworthy” property you can navigate to the following MSDN Article
The small little statement made my day, So I hope the above solution works out in your case as well.
In case you come across this issue.
Hope it helps !!!