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 20, 2023 at 8:55 am

    #4193527

    Excuse my ignorance, but what is an EAP source?

  • 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.

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

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