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,
Microsoft SQL Server

Avatar of undefined
Last Comment
PedroCGD

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
PedroCGD

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61