Hi, I need to distribute an SSIS package to another person to use in a demo, but it is very important that I retain the IP, so must only provide him the ability to run the package, and disable the ability to open, view or modify the package. But I am not sure how to achieve this. It seems that EncryptAllWithUserKey will allow "only the user who created the package..." (me) "...to open, view and/or modify, and run the package" - this is part what I need albeit I need to allow someone else to run it. The EncryptAllWithPassword option protects with a password, but it is unclear if I provide the password to the user who must run it, if he will be able to open, view or modify the package. What are my options? Thanks 'If this was helpful, please mark and an answer or as being helpful'

There is no such option available. I'm thinking about the following workaround. 1. Create .NET executable and embed the package into your app as resource. 2. Your app should use the SSIS API to execute the package you have stored inside. 3. As additional protection measure you can do simple mangling of the stored package and then you can obfuscate your application.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/