Microsoft KB Archive/912911

= How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step =

Article ID: 912911

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems

-



SUMMARY
This article describes how to run a Microsoft SQL Server 2005 Integration Services (SSIS) package as a SQL Server Agent job step.



MORE INFORMATION
To run an Integration Services package as a SQL Server Agent job step, use one of the following methods.

Method 1

 * 1) Create a SQL Server Agent job step that runs the package. When you create the job step, click SQL Agent Service Account in the Run as list in the New Job Step dialog box.

Note You must be a member of the sysadmin fixed server role to specify SQL Agent Service Account for the job step.
 * 1) Grant the appropriate permissions for the SQL Server Agent service account so that the SQL Server Agent service account meets the security context requirement for the package.

Note These permissions are required for the package to access the necessary resources.

Method 2
 Create a Microsoft Windows user account that meets the security context requirement for the package. Create a credential in an instance of SQL Server 2005.

Note A credential is a record that contains the authentication information. The authentication information is needed to connect to a resource that is outside SQL Server. Create a SQL Server Agent proxy in the instance of SQL Server 2005. When you create the SQL Server Agent proxy, perform the following operations for the SQL Server Agent proxy in the New Proxy Account dialog box:  In the Credential name box, click the credential that you created in step 2. Under Active to the following subsystems, click to select the SQL Server Integration Services Package check box.

Note SQL Server Agent proxies define the security context for a job step. SQL Server Agent proxies use credentials to store information about Windows user accounts. The user who is specified in the credential must have the &quot;Log on as a batch job&quot; permission on the computer that is running SQL Server 2005. You can grant the &quot;Log on as a batch job&quot; permission to a user in the Local Group Policy Editor. Create a SQL Server Agent job step that runs the package. When you create the job step, click the SQL Server Agent proxy that you created in step 3 for the job step in the Run as list in the New Job Step dialog box.</li></ol>

After you schedule the package, SQL Server Agent may not run the package as a job step successfully. However, if you run this package outside SQL Server Agent, the package can complete successfully. If this problem occurs, click the following article number to view the article in the Microsoft Knowledge Base to troubleshoot the problem:

918760 An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step

<div class="references_section">