Create a job for a SSIS package with configuration file

In this post, we will learn how to create a new job for the SSIS package with package configuration.

Here I have a package. This is a simple package which is used to move some files from one folder to another folder.

   

Now I am going to create a SQL server agent job in SQL server for this package.

Right click on the job and select the new job. In the General tab, we will provide the job name and descript  

Go to the steps tab and add a new step

   

Write the step name and select Type as SQL Server Integration Services Package and Package source as File System and provide the Package path where the packaged stored.

Now go to the Configuration tab.

   

Select the configuration file

Click ok

A new job is created

 

See the configuration file

  

Running this job.

                              

Job completed successfully.

  

See the archive folder.

  

Now we will change the configuration as below

   

       

See the Archive folder in H drive

Now running this job aging after making changes on the configuration file.

  

See the files on the archive folder.

   

Hope this will help to create job in SQL Server Agent and add package configuration file into this job.