sql Server agent STATUS Failed. The SSIS package executed successfully

B B 1 Reputation point
2020-08-21T17:24:17.747+00:00

Hello , I am bumping into a strange problem. My SQL Agent job reported failure ( Pic. 1), while the step SSIS Package reported success ( Pic. 2 ) and the package did not show any error message in the log.
Any idea how to find out/troubleshooting more details about an error, rather than just that it is failed.
FYI:
The step 16, is the last step of the job.
Slq Version: 13.0.5698.0
SSDT: 12.0

Pic. 1
19460-image.png

Pic. 2
19459-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,901 Reputation points
    2020-08-24T03:19:07.323+00:00

    Hi BB-1854,

    Please set Logging level as Verbose in Job Step Properties.

    The following links and pictures will be helpful:

    Set the logging level for a package by using the Execute Package dialog box

    Logging Level Recommendations for the SQL Server Integration Services Catalog

    19608-joblogginglevel.png
    19811-cataloglogginglevel.png

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.