Job failed with error when calling SSIS package in sql agent job. RRS feed

  • Question

  • Hello,

    I have created a ssis packages using server administrator login in SSIS 2016  and i deployed that project in to ssis integration catalog.  

    then i created a job and calling these packages in to sql agent job.But while executing that job i am getting below error.

    may i know what i the issue here. any one can help to fix the issue.

    Executed as user: XXXXERPServer\Administrator. Microsoft (R) SQL Server Execute Package Utility  Version 13.0.5026.0 for 64-bit  Copyright (C) 2016 Microsoft. All rights reserved.    Started:  9:52:13 AM  Package execution on IS Server failed. Execution ID: 215279, Execution Status:4.  To view the details for the execution, right-click on the Integration Services Catalog, and open the [All Executions] report  Started:  9:52:13 AM  Finished: 9:52:19 AM  Elapsed:  5.75 seconds.  The package execution failed.  The step failed.

    Monday, June 29, 2020 4:23 AM

All replies