The process exit code was "1" while the expected was "0" Error

sql dev 6 Reputation points
2023-06-09T09:25:52.04+00:00

The following error keeps occurring intermittently, the issue is not with permission because it works fine the majority of the time and no changes have been made to the ssis package.

Would you please let me know what the following Error means?

The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 04:00:01 Finished: 00:48:42 The package execution failed. The step failed.

Thank you in advance!

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,764 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,458 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2023-06-12T02:00:05.3866667+00:00

    Hi @sql dev，

    Are you using Execute Process Task in your package?

    If so, could you please share the settings of the component?

    If not, please enable the logging to get more details.

    Regards，

    Zoe Hui

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

    0 comments