SSIS Unexpected Termination While running a packages through SQL Job

Raj Kumar A 6 Reputation points
2024-03-21T16:09:58.2766667+00:00

Hi Everyone,

support required for the below error

My SSIS package execution failed with unexpected termination while running through SQL jobs.

Package Purpose:

To Load multiple .xlsx files to SQL tables using Foreach Loop Container.

User's image

Sometime job gets succeeded and all files being loaded to table. most of the execution failed with unexpected termination.

All the time package stuck while Data Flow task: Prepare for execute phase is beginning.

However, same package works perfectly when I run from visual studio.

User's image

User's image

Thanks,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Raj Kumar A 6 Reputation points
    2024-03-22T02:52:28.7233333+00:00

    Always package stuck while Data Flow task: Prepare for execute phase is beginning and throws unexpected termination.

    0 comments
  2. ZoeHui-MSFT 34,756 Reputation points
    2024-03-22T08:29:56.48+00:00

    Hi @Raj Kumar A,

    The error message is a bit general for us to narrow down the issue.

    How do you design the data flow? Please make sure you have set the validation delay on the task level?

    Could you please try to re-deploy the package and run it manually in agent job?

    And also make sure you have full access to the source and destination.

    Regards，

    Zoe Hui

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

  3. Ssis operator 0 Reputation points
    2024-04-29T18:09:44.1133333+00:00

    Were you able to find the problem? I have the same issue..

    0 comments