SSIS Configuration Settings

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";