1 year ago
#328774
user6787720
SSIS Derived column throw's error for Decimal(17,2) datatype
Using ODBC Source to read data from Hadoop and insert them in OLE DB destination. Performing conversion operations on various columns using derived column on various column. I have Column "POPrice" in destination with datatype Decimal(17,2) and in source Decimal(13, 2) without providing any conversion expression in derived column directly passed to destination but after inserting some rows, program gets terminated with error. If removed derived column then it is working fine.
Any assistance please?
ssis
odbc
etl
oledb
derived-column
0 Answers
Your Answer