ODBC connection throwing error while reading data from EAP - SSIS

• kirti

  Old Hand

  Points: 387

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• kirti

  Old Hand

  Points: 387

  More actions

  May 20, 2023 at 10:48 am

  #4193561

  We are connecting to a hadoop cluster

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel