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

1 則留言: