How to Correctly Execute an SSIS Package as a SQL Server Agent Job Step?

How to Run an SSIS Package as a Job Step in SQL Server Agent

Your SQL script for creating a SQL Server Agent job to run an SSIS package appears correct. However, the error you mentioned regarding incorrect syntax near '/' suggests a potential issue in the command used for executing the package.

Correct Syntax for Executing an SSIS Package in a Job

The proper syntax for executing an SSIS package as a job step is:

/file "<package_path>"

where:

• is the absolute path to the SSIS package file (*.dtsx)

Alternative Option: Using the Graphical User Interface

If you encounter any further issues, you can alternatively create the job using the graphical user interface in SQL Server Management Studio. Here are the steps:

1. Right-click on Jobs under SQL Server Agent and select New Job...
2. Specify the job name, owner, description, and category in the New Job dialog.
3. In the Steps section, click New...

4. In the New Job Step dialog, configure the following:

   • Step name: A name for the step
   • Type: SQL Server Integration Services Package
   • Run as: Service Account or Proxy
   • Package source: File System
   • Package path: Browse to the SSIS package file
5. If necessary, apply any configurations in the Configurations tab.
6. Click OK to add the package step.

Additional Notes

• Ensure that the SSIS package is properly designed and has no errors.
• If using a proxy account, grant the appropriate permissions to the account.
• You can use the Script Job as --> CREATE To --> New Query Editor Window option to generate the SQL script for the job.

The above is the detailed content of How to Correctly Execute an SSIS Package as a SQL Server Agent Job Step?. For more information, please follow other related articles on the PHP Chinese website!