• opc.three (3/14/2013)


    Have a look into EncryptSensitiveWithPassword the option. You could also look into using a Package Configuration (of some kind) to store the connection string with the password in it but the password would not necessarily be protected in that scenario.

    I'll second the package configuration suggestion - that's how I would do it.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.