SSIS – Error while deploying ISPAC, Is your SSISDB trustworthy ??

Hi,

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:

ssis_error1

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 !!!

Leave a Reply

Your email address will not be published. Required fields are marked *

*