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.
Method
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.
