August 29, 2012 at 7:00 am
Hi Friends,
My project is under SSIS 2008, SQL 2008. there is a column from OLEDB source coming as DT_NTEXT. So obviously i have to convert to DT_TEXT and i do in the data conversion task. but truncation problem arises due to large values. How to over come this situation?
Please gimme your suggestions friends.....
Thanks,
Charmer
August 29, 2012 at 8:01 pm
You cab try using the Export Column transform. This is specifically meant for datatypes like DT_NTEXT etc.
August 30, 2012 at 12:25 am
How can there be a truncation error when converting from unicode to non-unicode? Both are CLOB datatypes without a length specified.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply