SSIS Package Error -- DTS_E_PROCESSINPUTFAILED

Saurabh Karemore 0 Reputation points
2023-01-21T02:38:20.5733333+00:00

I have a SSIS package deployed in SQL SERVER 2016,which returned the following error.

DIM ReasonCodeFirstPass:Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component

"OLE DB Command" (122) failed with error code 0xC0202009 while processing input "OLE DB Command Input" (127). 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.

Can anyone provide the resolution for the same?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,453 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,643 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 34,461 Reputation points MVP
    2023-01-22T03:12:50.4266667+00:00

    This error is probably occurring because you have a value in your source for one column that is not valid for the same column in the destination.

    Continue reading after the "... error code 0xC0202009" and you will find the specific column having no valid values after reading something like ".Inputs[OLE DB Input].Column".

    Make sure the destination column can handle the length of the data coming from the source or the number of digits and decimals coming from the source, in case is numeric data.

    Hope this is the case.

    0 comments No comments

  2. ZoeHui-MSFT 40,431 Reputation points
    2023-01-23T01:35:30.7066667+00:00

    Hi @Saurabh Karemore

    DIM ReasonCodeFirstPass:Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.

    There may be error messages posted before this message which will tell us the reason for the issue, please have a double check.

    Regards,

    Zoe Hui


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


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.