After this:
when 'text' then 'cast([' + column_name + '] as varchar(max))'
add this:
when 'ntext' then 'cast([' + column_name + '] as nvarchar(max))'