New answers tagged oledb
Thanks for your advice. I found the issue. It was due to different date formats being used in Oracle data. The year part was yyyy for some dates, while just yy for other dates. So for eg: when a user enters '98 as the year, the system saved it as 0098 rather than 1998. Hence, the data was not processed at oledb source itself in bids.
You need to use derived column transformation and with help of expressions perform required conversion operation on original columns. To replace null with default value use REPLACENULL(expression 1,expression 2) in derived column transformation. REPLACENULL returns the value of second expression parameter if the value of first expression parameter is ...
Top 50 recent answers are included