Problem: When SSIS packages are deployed to production SQL Server (which is the server of the CUSTOMERS and not that of VENDORS), DBAs can export the project, open it on Visual Studio and make changes to packages or worse, copy the logic inside them.
Is it possible to encrypt the SSIS project and then deploy it on SQL server in the encrypted form ?
I have already tried to change protection level of packages, but while deploying it the wizard changes this protection level [screenshot] and users can EXPORT the packages and still problem is not solved. After researching I found out that this is the default behaviour and that protection levels work only inside SSDT not on SQL Server.
Other alternatives included DIGITAL SIGNING of packages but I want to make sure that this will work before implementing it. As far I as read implementing this approach, the DWORD registry key had to be set, as such this doesnt comply with my requirement since this registry would have to be set on clients and not before the deployment.
My question is how to handle this problem, I just want to deploy SSIS packages in an encrypted form, and to not allow users of SQL server to export them.
Thank you !