SSIS package hangs on validation

Nicky 116 Reputation points
2023-03-18T01:18:19.04+00:00

I have an SSIS package which has been running successfully from a very long time. Today there was issue with package going into never ending loop.

Package has 7 parent package execution tasks which calls child package. 6 packages runs fine and 7th get stuck in validation state.

All packages loads certain tables from source and dump them into destination staging area.

will really appreciate any help.

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.
12,585 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,446 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 32,406 Reputation points
    2023-03-20T05:32:15.3033333+00:00

    Hi @Nicky

    It is a bit hard for us to narrow down the issue.

    Could you please enable error logging to see if there is more message about the issue.

    Please also check the connection manager and make sure it works.

    If possible, you may re-add the components in the 7th package.

    Regards,

    Zoe Hui


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

    0 comments No comments