SSIS configuration settings can be set in 3 different levels…

  1. In the SSIS package itself.
  2. In the SSIS package configuration section on the server.
  3. In the job step configuration section on the server.

Note: The settings configured in the job step will overwrite settings set in the SSIS package configuration section.

Sample Database Connection

Data Source=MyServer01;Initial Catalog=MyDB01;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto
Data Source=MyServer01;Initial Catalog=MyDB01;Provider=SQLNCLI11.1;Integrated Security=True;Application Name="My SSIS Package-{7124CB77-9E52-4516-1131-AEE5D911AC3D}..MyDB01";
Last modified: January 6, 2021



Write a Reply or Comment