SQL job & SSIS package excution

  • Hi SQL experts,

    We have installed SQL Server with 2022 and using this as SSIS server. SSIS DB is the only one database on this server. We deployed a SSIS package, which is scheduled to run every 1 hr through SQL agent job.

    The job is failing sometimes & running successfully other times.  The job is failing with the message showing package execution on IS server failed. From integration services catalogs, All execution is showing status as unexpected termination but it is not providing any errors. From the execution overview each task showing as succeeded but final status is showing as unexpected termination. The job is failing more than 4 times a day. Unable to find any error from SSIS DB. When all individual tasks are succeeding how the status is showing unexpected termination for some runs & how to identify what causes the unexpected termination?

    • This topic was modified 1 month, 1 week ago by  ramana3327.
  • What is the source and destination? which step is failing?

    Regards
    Durai Nagarajan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply