SSIS package using SQL Authentication on SQL Server Agent

 

1. SQL Server Business Intelligence Development Studio > SSIS tab > Package Configurations Organizer > Enable Package Configurations > Click Add > Type : XML configuration file >  Set up file path and name > Next > Select Connection manager >  Select Connection and pick Password.
   

2. Open configuration feil from you store path. > Add Password in <ConfiguredValue> element :
     <ConfiguredValue>PasswordSample</ConfiguredValue>
   

3. Add configuration file in you SQL Server agent.

Reference : SSIS package using SQL Authentication and DontSaveSensitive as ProtectionLevel