Memo field da Access into varchar SQL server

I'm having some problems importing data from a memo column (Access) into varchar column in SQL Server.

My idea was to use slowly changing dimesion to identify modified and new rows. No matter what data type I use to convert the memo column (using Data Conversion Transformation) and then using the converted column in SCD, I get the following error :

'The SCD transform does not allow mapping between columns of different types except for DT_STR and DT_WSTR.'

What do I have to do to get Memo column 'to behave' as a string

Same problem with a different data type - decimal (18,5) in sql server - no matter what datatype I use in Data Conversion Trans, I get the same error trying to generate scd.

Thank you for your answers.

Memo type in Access is mapped to DT_NTEXT in SSIS. DT_NTEXT is considered a BLOB type in SSIS and some transforms (like lookup) do not support joining on BLOB type column.

When I modified my destionation column's type into nvarchar(max), the scd gives me this error - Slowly Changing Dimension : The input column x has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE which is not supported.

Does that mean that I can't use the scd to determine if the column x has been modified

My access Memo filed is, in fact, plain text. Is there any work around I'd like to confront my Access field and my SQL field in order to know if any modifications have been done. Is it possible