SQL Server Agent Service

Running SSIS packages can be automated using the SQL Server Agent service of SQL Server 2005. SQL Server Agent jobs can have one or more steps, each providing a different package and a bit of work that the agent can do for you. The jobs can also be scheduled to run at specific times. SQL Server Agent needs to be started before you can use it to run packages on the local server or send jobs to the target server.

Hands-On: Automating Running an SSIS Package with SQL Server Agent Service

In this exercise, you will learn how to use the SQL Server Agent service to create and automate jobs for running SSIS packages.


We will use SQL Server Agent in SQL Server Management Studio to

  • Create a new job

  • Add a package (step) ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.