January 27, 2009 at 10:00 pm
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.
January 28, 2009 at 5:18 am
My suggestion is to add an error output to the components that are giving you errors. Send those rows to a separate table with the error information or to a text file. Perhaps you can find the problem that way.
Russel Loski, MCSE Business Intelligence, Data Platform
January 29, 2009 at 7:19 am
You can change your select in the source connection to pull the top 318 and if it completes then you know that record 319 is bad. You might also try only pulling 1 column at a time thru the package and then you can find out which column has the bad record.
January 29, 2009 at 7:26 am
I want to agree with the set up the error output. It is also a good to run the whole set and look at all data that will cause you issues. May as well troubleshoot the whole data source at once.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply