Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This procedure describes how to create a step in a SQL Server Agent job that runs an Integration Services package. You must create a separate job step for each package that you want to run.
A job is associated with one or more schedules. For information about how to schedule the job to run the package specified in the job step, see How to: Schedule a Job (SQL Server Management Studio).
The account that runs an Integration Services package as a SQL Server Agent job step requires all the same permissions as an account that runs the package directly. For information about how to troubleshoot packages that are run from SQL Server Agent jobs, see the Microsoft Knowledge Base article, An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step.
For information about how to run a package immediately, see Running Packages.
In SQL Server Management Studio, open the instance of SQL Server in which you want to create a job, or the instance that contains the job to which you want to add a step.
Expand SQL Server Agent and do one of the following:
On the General page, if you are creating a new job, provide a job name, select an owner and job category, and, optionally, provide a job description.
To make the job available for scheduling, select Enabled.
Click Steps, and then click New.
Provide a step name and, in the Type list, select a job step type that is based upon the version of the dtexec utility (dtexec.exe) that you want to run the job:
In the Run as list, select the proxy account with the credentials that the job will use. For more information, see the following topics:
On the General tab, select the package source. If the source is SQL Server or the SSIS Package Store, provide the server name, select the authentication mode to use, and then provide the name of the package, or click the ellipsis button (…) and select the package. If the source is the file system, provide the path and name of the package, or click the ellipsis button (…) and locate the package.
Important
For password-protected SSIS packages, click the Configurations tab to enter the password in the Package Password dialog box. Otherwise, the SQL Server Agent job that executes the password-protected package will fail.
To specify command-line options, do the following:
Click the Command Files tab to specify the files that contain the options that the package uses.
Click the Command Line tab to edit or restore the command-line options.
Click the Configurations tab to add configuration files and, optionally, export configured variables to a file.
Click the Data Sources tab, select the connection manager check box and then update the connection string.
Click the Execution Options tab to specify the package run-time behavior such as whether the package fails if warnings occur.
Click the Logging tab to add log providers. Select a log provider in the Log Provider list and then type the connection string.
Click the Set Values tab to map properties and variables to values.
Note
The property path uses this syntax: \Package<EM><container name>.<property name>. Depending on the package structure, a container may include other containers, in which case nested containers are separated by a back slash (). For example, Package\MyForeachLoop\MySequence\MyExecuteSQLTask.Description.
Click the Verification tab to specify whether only signed packages can run and to specify the version of package to run.
Click OK.
Scheduling Package Execution in SQL Server Agent
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in