Post reply

ODBC connection throwing error while reading data from EAP - SSIS

  • May 19, 2023 at 10:33 am

    #4192941

    Hi,

    I am using ODBC connection manager to fetch data from EAP source in SSIS

    It is throwing DTS_E_INDUCEDTRANSFORMFAILUREONERROR on 1 of the columns PipelineOwnerName which is varchar(121) in EAP table.

    I have tried these approaches:

    • select PipelineOwnerName from Sales where Period = '2021' --- Failed

    select cast(PipelineOwnerName as varchar(121))  from Sales where Period = '2021' -- Failed

    Explicitly set the advance editor I/O property to DT_STR(length 121) for  PipelineOwnerName -- Failed.

     

    Package is failing while reading data from ODBC itself.

    Any pointers to try will be helpful.

     

    Thanks

  • May 19, 2023 at 11:19 am

    This was removed by the editor as SPAM

  • May 20, 2023 at 8:55 am

    #4193527

    Excuse my ignorance, but what is an EAP source?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • May 20, 2023 at 10:48 am

    #4193561

    We are connecting to a hadoop cluster

  • May 20, 2023 at 10:50 am

    #4193562

    kirti wrote:

    We are connecting to a hadoop cluster

    Then I cannot help, unfortunately.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply