SQL-Articles
On Premise and Cloud Database Knowledge Base

How to Schedule SSIS package

Scheduling a SSIS package is not like scheduling DTS packages in SQL 2000. In SQL 2000, you will move to DTS package and then right click from there you can get the schedule menu, but for SQL 2005 its no more like that. You should schedule the SSIS packages as below.

* In SQL 2005, you should create a job to schedule SSIS package, go to New Job and provide the job name

schedule_ssis_package_1

* Then go to steps tab and click on New button to insert a new step & provide step name

schedule_ssis_package_2

* Here where you are going to tell that SSIS package is going to be scheduled. In the Type select SQL Server Integration Services Package. Then you will get the window as below.

schedule_ssis_package_3

* Here you need to specify the server name from where the SSIS packages should be taken, then provide the authentication details, (i.e windows or sql), After providing the server name & authentication the Package will be enabled and you can select SSIS package.

schedule_ssis_package_4

* You can click on the button shown with red arrow mark to select the SSIS Package that you need to schedule, you will be popped with the below window.

schedule_ssis_package_5

* After selecting the SSIS package, the package name will be displayed in the package column as shown below.

schedule_ssis_package_6

Click on OK to save the step, then go to the schedules tab and provide the timing for schedule.

Leave a Reply

2 comments

  1. After Successful completion of one job scheduler i need to start the another job in another database how can i do it?

    is that possible through coding or should i go with the wizard as you shown above.

    1. You can add a new step with the below command to start the job.

      EXEC msdb.dbo.sp_start_job @job_name=’My Job’

      If you want to start in another server then change the step type to operating system and then use the below command

      SQLCMD -E -SServer1 -dmsdb -Q”EXEC msdb.dbo.sp_start_job @job_name=’My Job'”

Leave a Reply to Harini Cancel reply

Your email address will not be published. Required fields are marked *

*