1 year ago

#328774

test-img

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

Accepted video resources