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

    Question

  • 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 11:53 AM

Answers

All replies