Getting error while getting data from source using ssis data flow task

_{Tuesday, January 22, 2013 11:53 AM}

I am getting data from ADO.net source to load into the table using ssis  but in the data flow task while getting from the source  its giving the following errors.

[ADO NET Source 1 [2028]] Error: The "component "ADO NET Source 1" (2028)" failed because truncation occurred, and the truncation row disposition on "output column "Customer_GroupID" (3521)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

[ADO NET Source 1 [2028]] Error: The component "ADO NET Source 1" (2028) was unable to process the data. Pipeline component has returned HRESULT error code 0xC020902A from a method call.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "ADO NET Source 1" (2028) returned error code 0xC02090F5.  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.

[ADO NET Source [1]] Error: The component "ADO NET Source" (1) was unable to process the data. Exception from HRESULT: 0xC0047020

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "ADO NET Source" (1) returned error code 0xC02090F5.  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.

The Customer_GroupID column data type in the source is Unicode String [DT_WSTR] and length is 6.

And in the destination the data type of this column is nvarchar(30).

I am not getting any idea how to solve this.

I need help to solve this issue. what is the reason of this error.

_{Tuesday, January 22, 2013 3:54 PM ✅Answered}

I suggest you to check these threads which address your problem:

1. Least Helpful SSIS Error Message: DTS_E_PRIMEOUTPUTFAILED
2. SSIS Error Code DTS_E_PRIMEOUTPUTFAILED

But, i think the error is being raised because one of your columns is being truncated when importing it from source system. Check the first error message on "Customer_GroupID".

_{Friday, January 25, 2013 10:51 AM ✅Answered}

You may need to explicitly CONVERT the datatype of the source column using CONVERT(NVARCHAR(6)) in the source query, or change the length of the column to 60, under the task's Advanced Properties -> Input Columns

_{Wednesday, November 6, 2019 9:55 PM | 1 vote}

Hi,

Had the same error.

I adjusted the CommandTimeout from 30 to 90 seconds and that worked for me.

You'll need to adjust it for very large queries otherwise it'll timeout.

Doubt you'll read it since this was 6 years ago but alas someone else may benefit ;)