O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Scheduling an SSIS package execution

In this recipe, you are going to create an SQL Server Agent job with a single step using an SSIS package, configured with a specific SSIS environment. You are going to assign a schedule to the job so that it can be executed automatically.

SQL Server Agent is a special SQL Server feature, hosted on the SQL Server instance, which supports the automation of a variety of operations and processes. One of them is the execution of SSIS packages; these can be configured as one or more steps of an SQL Server Agent job.

SQL Server Agent and SQL Server Agent jobs SQL Server Agent is available in SQL Server 2016 Enterprise, Standard, and Web editions; it is not available in the Express, nor Express with Advanced ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required