Share via

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,508 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 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.