Monday 31 December 2018

Create a job for a SSIS package (File System)

In this post, we will learn how to create a new job for the SSIS package.
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.
   

A new window will be open. In the general tab, we need to add the job details.
   
   
Now go to the Steps tab. And click on the new
  

Write the step name and select Step type SQL Server Integration Service package.
       
   

Select Package Source as File System and provide the Package location.
Now click ok.
Step created successfully.  

Click ok.
A new job created successfully.
   

Before running this job
  

Now running this job.
    
Job completed successfully.
Now see the files in the archive folder.
  

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts