Schedule SSIS package execution

Question

How do I schedule every day for SSIS to run a program from a file automatically at a given time?

Answer 1

You have a few choices, but I'm going to give you something that will encourage you to get up and run quick...

• Open SQL Server Management Studio, and link to the SQL Server's Database Engine running the job. This SQL Server should be installed and running on SQL Server Agent.
• Expand Agent SQL Server, expand Work.
• Right-click and choose New Job.
• When creating your package stage, choose SQL Server Integration Services Package for Instance. Choose File system for the root of the Kit. You can then use the browsse button(...) to search the file system for the DTSX package for the Collection.
• Go to Schedules and build work schedules just like you would usually do for any other SQL Server Agent task. Set the Frequency to Regular in your case, and set Occurs value once at whatever time the job should be going.
• Make sure the SQL Server Agent service account has the permission to access the dtsx package on the filesystem (this is the default, you can choose an alternate protection context if needed).
• This will only function if the server you are scheduling the job on is also the server for Integration Services. There are many ways to handle remote execution of packages if you need it.

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server.