I used to have a DTS package that used SQL Server authentication. The userid password was stored in the package itself. Now that I have moved to SSIS, the password is not getting stored to the package. I saw SSIS Connection Manager passwords when I googled the problem, but no one seems to have given a good resolution.

sql-server sql-server-2005 ssis
Edit
Report