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