x

DTS_E_PROCESSINPUTFAILED. The processInput method on component "InsertedData" (344) failed with error code 0XC020844B

I am using a CDC Incremental update using two SSIS packages: one for initial load and another for Incremental update that is failing. The package works fine in DEV environment but fails in Production with the error code:

"DTS_E_PROCESSINPUTFAILED. The processInput method on component "InsertedData" (344) failed with error code 0XC020844B while processing input "ADO NET Destination Input" (351). 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."

Once a while the job would run successfully. And I have another CDC Incremental that behave exactly the same way. Other SSIS non-CDC are running fine. Running SQL server 2014 Enterprise on Win2k12.

Any ideas?

Thanks!

more ▼

asked Jan 27 at 06:26 PM in Default

avatar image

tounkara
60 1 1 3

What is the component "InsertedData"?

Jan 31 at 01:31 PM nidheesh.r.pillai
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

alt text

alt text

more ▼

answered Jan 31 at 07:32 PM

avatar image

tounkara
60 1 1 3

(comments are locked)
10|1200 characters needed characters left

The INSERTEDDATA is a dataflow task to collect inserted data vs. DELETED or UPDATEDDATA

more ▼

answered Jan 31 at 07:33 PM

avatar image

tounkara
60 1 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1221
x11

asked: Jan 27 at 06:26 PM

Seen: 191 times

Last Updated: Jan 31 at 07:33 PM

Copyright 2017 Redgate Software. Privacy Policy