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 1 hours, 56 minutes 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.

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

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