Scheduling SSIS Package in SQL Server Agent

 STEP-1 - Creating Variables

Create Variables for for you connections as shown below

 STEP-2 - Connecting variables to connection managers

Right click on the connection for which you need to change it to a variable and click Properties

Click on the 3 dots on the right of Expressions and assign the variables to property as shown below

 STEP-3 - Convert to Deployment model

Click on the project and select convert to package deployment model

 STEP-4 - Change ProtectionLevel property of package

Change the PropectionLevel property to DontSaveSensitive

 STEP-5 - Creating configuration file

Right click inside the flow and click on package configurations

Enable Package configuration --- Add--Select the folder and name to file to be saved

Note: Select the folder which is accessible by your SQL Server agent

 STEP-6 - .Config file creation

Click on the whole package and Click next

Name the configuration and close it. Now the configuration file will be created in the folder you selected.

 STEP-7 - Copying the package to the common location

Now copy the package and place it in a same folder where you placed the configuration file.

File can be copied as shown below

 STEP-8 - Configuring job in server agent

Create a new job. Under Step, create a new step as shown below

Under Configuration select configuration files

 STEP-9 - Testing the Server agent job

Right click on the created job and click Start Job at Step to test the job is running successfully.