Link to home
Start Free TrialLog in
Avatar of dewacorp_alliances
dewacorp_alliancesFlag for Australia

asked on

SSIS: Debug on Data Flow Task

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,
ASKER CERTIFIED SOLUTION
Avatar of PedroCGD
PedroCGD
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial