Hello Friends, I am trying to create an SSIS package for migrating data from MSAccess to SQL 2008 and getting an error :Conversion from "DT_NTEXT" to "DT_STR" is not supported Conversion from "DT_NTEXT" to "DT_STR" is not supported I researched online about this error and found out that there are two steps are involved to solve this issue Two steps involved in this: 1. Convert DT_NTEXT to DT_WSTR 2. Convert DT_WSTR to DT_STR<o:p></o:p> I am new to ssis ----i am using following method ---- Oldb data source---->Data Conversion----->Destination Now the question i have ..how to convert DT_Ntext to DT_WSTR and then from DT_WSTR to DT_STR on a same column I would appreciate if someone can give me a walk through on this...

You could do it in a derrived column block rather than a data conversion block. Something like this should work - adjust your size from 255 to whatever is appropriate (DT_STR, 255, 1252 )((DT_WSTR, 255 )column1) Or if it is easier for you just use 2 data conversion blocks (Source-DataConversion-DataConversion-Destination) Convert it ot WSTR on the first one and STR in the second Chuck

Hello, You can use a Derived Column Transformation to convert datatype of you input column.Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Thank you OldJeep and Olaf Helper for your quick response. OldJeep i have a question for you on a solution you suggested above ...Using 2 data conversion blocks....I've attached a screenshot for your reference. Could you please take a look tell me if that is what you were trying to explain ...

Two Data Conversion components would work fine too (although I'm not entirely sure why you'd need two separate conversion steps - but whatever). Use the first to convert to a DT_WSTR, then the second to convert to a DT_STR. But I imagine that hasn't worked for you - so what is the problem now? Talk to me now on

Thanks Todd for your reply... you were right ...i am still getting the same error message

You can't be getting the same error message, because you're using two steps. Please let us know exactly what you're doing now. What columns are being converted in what way in each component? Talk to me now on

Todd..you were right....I was not doing the mapping correctly in the destination block but after little struggle i could fix the issue.. Thank you guys once again for all your help.