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

Near real-time and on-demand loads

Triggering loads using SQL Server Agent has some limitations. For one, we cannot run the job more than once at a time. Another limitation is that it is hard to trigger jobs programmatically. There is a stored procedure called sp_Start_Job that can do it. It starts the job but doesn't wait for it to complete, so we can't have the execution status (success, failed) returned by the job. We can use TSQL scripts that pool the job status while it's executing but still, it's not an out-of-the-box solution.

When using SSIS project-model deployment, package execution can be called via TSQL. This recipe will show you how it can be done.

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