We help IT Professionals succeed at work.
Get Started

SSIS: Debug on Data Flow Task

3,774 Views
Last Modified: 2013-11-10
Hi there

I am trying to figure what is wrong with my Data Flow Task that I have. I have component like this: OLEDB Souce > Conditional Split > Derived Column > OLEDB Destintion. The OLEDB SOurce is about 1.4 million records

Now I did setup Data Viewer between Conditional Split and Derived Column as well as Derived columns and OLEDB Destination.

When I ran it:
1. The first Data Viewer comes out only up to 318.
2. Those components are in yellow.
3. If I click PLAY button in the Data Viewer, the Conditional Split turn to GREEN and Derived Column are in RED.

My question are:
1) I know that there are some issue on that Derived Column but I don't know which one is causing the issue. How do I know which column is causing the issue? I had a look on the PROGRESS and it did mentioned about the source type could not be converted.

2) If the that Data Viewer stop at record Rows Dispplay (318) and RowID = 10082035, does thi mean that there is an issue on next row or in this row?


Here's the error that I got in the Progress:
[DC Derived Column [2859]] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.
[DC Derived Column [2859]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "component "DC Derived Column" (2859)" failed because error code 0xC0049062 occurred, and the error row disposition on "output column "Derived Column3" (18040)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "DC Derived Column" (2859) failed with error code 0xC0209029. 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.
[TelstraOBSFlexCabCSVBatchItems [1202]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED.  Thread "WorkThread0" has exited with error code 0xC0209029.  There may be error messages posted before this with more information on why the thread has exited.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "TelstraOBSFlexCabCSVBatchItems" (1202) 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.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED.  Thread "SourceThread0" has exited with error code 0xC0047038.  There may be error messages posted before this with more information on why the thread has exited.



Thanks,
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE