SSIS package is executing fine in visual studio but slow down in SQl agent

Naresh y 146 Reputation points
2023-06-06T16:24:46.07+00:00

Hi All

i have one stage package which is executing in VS 2019 successfully but when calling from Sql agent its failing.

the below is the error mesagae

Message

Executed as user: abc\user. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4312.2 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 9:13:06 AM Error: 2023-06-06 09:13:09.92 Code: 0xC0209022 Source: DFT CV_Stage_Load DC ANSI [2]

Description: Directing the row to the error output failed with error code 0x80070057. End Error Error: 2023-06-06 09:13:09.92 Code: 0xC0047022 Source: DFT CV_Stage_Load SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "DC ANSI" (2) failed with error code 0xC0209022 while processing input "Data Conversion Input" (3). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2023-06-06 09:13:10.00 Code: 0xC02020C4 Source: DFT CV_Stage_Load ODBCS Get CV_Stage Data [65] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2023-06-06 09:13:10.00 Code: 0xC0047038 Source: DFT CV_Stage TS Load SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ODBCS Get CV_Stage Data returned error code 0xC02020C4.

The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:13:06 AM Finished: 9:13:10 AM Elapsed: 3.766 seconds. The package execution failed. The step failed.

this is the error ,i tried couple of way but not fixed my issue,could you please suggest on this issue ASAP

Thank you!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,286 Reputation points
    2023-06-07T02:38:28.66+00:00

    Hi @Naresh y,

    There may be error messages posted before this with more information about the failure.

    Is there any more message when you run the package?

    Executed as user: abc\user. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4312.2 for 64-bit Copyright (C) 2019 Microsoft.

    It seems that you are using Utility to run the package, could you please use the 32bit to run the package?

    Regards，

    Zoe Hui

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

    0 comments