Francisco Tapia
fhtapia at gmail.com
Wed Feb 24 14:01:59 CST 2010
connect back to management studio... (integration services) locate your package, export package to server again choose protection level: Do not save sensitive data -Francisco http://sqlthis.blogspot.com | Tsql and More... On Wed, Feb 24, 2010 at 11:41 AM, Stuart Dunlap <sdunlap at brownshoe.com>wrote: > Hi, > > I have an SSIS package that I created via the SSIS wizard. On the step in > the wizard called 'Save and Execute Package' there was a section in the > dialog box called 'Package Protection Level:' with a drop down option. For > this option I selected 'Encrypt sensitive data with password' and I entered > my password. > > I have now decided that I would like to remove the password from the > package. Is there any way I can do this? I can open & execute the package, > and I can edit the package...but I want to get rid of the password. I don't > use SQLServer 2005 that often and I can't figure it out. > > Any insight is appreciated. > > Thanks, > Stuart > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >