Steve, Yes, there is an SSIS template file that you can modify to use as the basis of all new SSIS files. The setting in question comes from the default template (which is an XML file). This works for most of the file choices that you see when creating a new file inside of Visual Studio. The template files are inside of the Visual Studio folder on a user's hard drive.
As far as sharing templates across a group and keeping all of them is sync, that is a different problem, as the templates are located in folders on each developer's workstation. Search for "SSIS Package Template" You shouldn't have to delete the package and start over again based on that encryption setting. Just have the package creator open the package, change the setting, and resave it. -Mike Chabot http://www.linkedin.com/in/chabot On Fri, Aug 19, 2011 at 11:45 AM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > Hi all, > > Sorry for the OT, but my Google foo has failed me! > > When trying to save a SSIS package to a server one of the options is > Protection Level and it defaults to "Encrypt data with User Key". The policy > in our shop is to use "Rely on server storage and roles for access control". > It is a major annoyance to always have to change it and when people forget > we have to delete the package and start over again. Does anyone know if > there is an xml file or something we can edit to change the default? > > Thanks, > Steve > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346865 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
