Summary

This article describes how to run a SQL Server Integration Service (SSIS) package from an adTempus job.

More Information

The simplest way to execute an SSIS package from adTempus is to use a standard Program Execution Task to run the dtexec command-line utility included with SSIS. Configure the task with the command line arguments necessary to execute your package.

Note that by default dtexec will submit your package and return immediately, without waiting for it to execute. If you want dtexec (and thus adTempus) to wait while the package executes and report its success or failure, you must set the $ServerOption::SYNCHRONIZED property to True for the package. You can do this by including the following as part of the command line for dtexec (more information):

/Par "$ServerOption::SYNCHRONIZED(Boolean)";True

With this option, dtexec will wait for the package and return an exit code of 0 for success or 1 for failure, which will cause adTempus to report the step as succeeded or failed.

Additional Resources

Refer to the dtexec documentation for complete information on command line parameters and usage considerations.