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

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo