Post reply

SSIS package failing intermittently on last Excel Component

  • April 27, 2026 at 9:49 am

    #4779678

    Good Afternoon,

    I have a Job which "fires" off an SSIS package (that is sitting on SSMS Integration Services Catalog). The package simply contains a series of components which pick up data from various SQL tables and places it into corresponding sheets in the same Excel File. Now the package fails intermittently on the last component (even though the preceding components are performing very similar action). Kindly advise.

    SSIS_Failure

    Regards

     

    • This topic was modified 2 weeks, 6 days ago by Reh23.

  • April 27, 2026 at 10:36 am

    #4779707

    Are you doing the Excel updates in series or in parallel?

  • April 27, 2026 at 11:05 am

    #4779736

    One after another...When one component succeeds, then the subsequent component commences to move data from its SQL Table to respective Excel sheet.

  • April 27, 2026 at 2:25 pm

    #4779893

    OK, sequential is good. I don't have much more to suggest.

    Perhaps you could try shuffling the processing order. This would help determine whether the problem is with that specific component, or simply with the final component, which would be useful to know.

Viewing 4 posts - 1 through 4 (of 4 total)

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