sql server dts: hi all,
I want to use ini files to store server details, but feel that storing
server username and password in ini file is not secure.
Any suggestions?

regards,

you could use integrated security and either store the server name in the
..ini or better yet use a .udl file. udl files were designed to store DB
connection info.

If this is not an option you could find an encryption libray that is
compatible with activex scripting and use this to encrypt and decrypt the
values in the config file

finaly, you could simply use EFS which is built into windows 2000 and later
this would require some advanced configuration to make the apporach work




[quoted text, click to view]