It's common to use SQL Server Agent to schedule and execute packages on the server. With Agent Proxies and Subsystems, it's simple to set up a secure job for executing a package. The following is a quick-start guide to setting up a job:
You can set other settings in the dialog boxes, but this is the basic setup and should be enough to get you started. For more information about setting up jobs, credentials, and proxies, search Books Online or MSDN. Caution Integration Services can be installed on a machine independent of SQL Server. However, the SQL Server Agent service relies on the SQL Server service. If you intend to use SQL Agent to schedule package execution, you need to have SQL Server installed on the machine as well. If you have some policies that don't allow SQL Server on the same box with Integration Services or otherwise govern the installation of SQL Server that prohibits you from running both servers on the same machine, you need to use the Windows Task Scheduler or some other such tool to schedule package execution. |