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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy