Schedule an SSIS package using windows task scheduler

There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. In this post, we will learn how we schedule our package using windows task scheduler.

Before scheduling the SSIS package we need to create a batch file to run the package.

Learn how to create a batch file.

Read here: Executing SSIS package from the batch file

https://bageshkumarbagi-msbi.blogspot.com/2019/02/executing-ssis-package-from-batch-file.html

I am using this package for the windows scheduler.

Windows task scheduler:

 The task scheduler enables us to automatically perform the routine task on the chose computer.

Step by step to create windows task scheduler

Open Administrative tool.

     

  

Click on task scheduler

   

Now click on the task schedule library

   

 

And select Create a task

In the General tab, we need to provide the Name of the job scheduler and description.

 

If we are creating this job on the server then we need to provide the AD group who have all access to run the sql server.

Now we go to the trigger tab.

Click on the new and here we need to create a new scheduler.

 

Here I am scheduling the package to run it on every 5 min and start at 10:30 PM.

Now we need to go the Action tab and select the batch file.

 

Click ok.

                      

Task has been created.

Before executing this task records in the table

 

Window task executed successfully on 10:40 PM (run details from 10:40 PM to 10:55 PM)

 

It run 4 times.

 

Hope this help you.