title: SSIS Connection Manager Not Storing SQL Password
body: <p>I used to have a <a href="https://en.wikipedia.org/wiki/Data_Transformation_Services" rel="noreferrer">dts</a> that had a sql server authentication connection. Basically, the userid password is stored in the package itself. Now, when I go to <a href="https://en.wikipedia.org/wiki/SQL_Server_Integration_Services" rel="noreferrer">SSIS</a>, the password is not getting stored to the package. I saw <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c720e694-2f58-483a-9cd7-3feb7de2db7b/ssis-connection-manager-passwords?forum=sqlintegrationservices" rel="noreferrer">SSIS Connection Manager passwords</a> when I googled the problem, but no one seems to have given a good resolution.</p>