[ACCEPTED]-Schedule SSIS package execution-scheduled-tasks

Accepted answer
Score: 47

You have a few options, but I'll give you 4 something that will allow you to get up 3 and running quickly...

  1. Open SQL Server Management Studio and connect to the Database Engine of the SQL Server that will run the job. This SQL Server should have SQL Server Agent installed and running.
  2. Expand SQL Server Agent, expand Jobs.
  3. Right-click, select New Job.
  4. When you create your package step, for Type choose SQL Server Integration Services Package. For the Package source, choose File system. Then for the Package you can use the browse button (...) to browse for the DTSX file on the file system.
  5. Go to Schedules and create job schedules as you normally would for any other SQL Server Agent job. In your case, set the Frequency to Daily, and set the value of Occurs once at to whatever time the job should run.

A couple of things 2 to keep in mind...

  • Make sure that the SQL Server Agent service account (this is the default, you can choose an alternative security context if needed) has the permission to access the dtsx package on the filesystem.
  • This will only work if the server on which you're scheduling the job is also the Integration Services server. There are plenty of ways to handle remote package execution if you require it.

For additional information, please 1 see https://msdn.microsoft.com/en-us/library/ms191439%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

Score: 8

I prefer the above anwser but it is also 4 possible with the windows Task Scheduler 3 and start your ssis package with dtexec. (Only 2 possible on the SSIS server) Check also 1 execution with dtexec

Score: 1

First choice - if possible is to to schedule 8 the package:

1) using the SQL Server Agent 7 for the standard jobs

2) non-standard windows 6 task scheduling, depends on what the package 5 is doing

3) dtexec can play nicely but it 4 depends on what ssis tasks the package runs

4) the 3 more the ssis package does, the more it 2 may require of the dtexec config and set 1 up to play nicely with the windows scheduler

enter image description here

More Related questions