bug with "slowly changing dimension" task and nvarchar(max)

Hello
I use SSIS to load a Unicode file into a single table
I Use a "slowly changing dimension" task to load the destination table and when i map a column (DT_WSTR) to a column with the datatype nvarchar(max) i have an error message that say that i can't map theses columns because there have not the same datatype.

I find a workaround : i map all my cols except the colums that must fill the cols with datatype nvarchar(max) , and after i modify manually the 2 subtask generated by the "slowly changing dimension" task (the insert and the update) and with this way i don't have error messages
It works fine but is it the good way

It seems to be a bug from ssis

Thanks in advance.

Nicolas Lievain

Answer this question

bug with "slowly changing dimension" task and nvarchar(max)

Jamesraj

nvarchar(max) is interpreted as DT_NTEXT in SSIS - DT_WSTR col can not be mapped to DT_NTEXT col, DT_NTEXT col can only be used as pass-thru col, these two are both by design.

I do not see how you worked this around - changing the downstreams won't affect SCD transform, you did not get error mesg, because, you did not map that column in SCD, so validation at SCD gave you green light.

thanks

Wenyang
bug with "slowly changing dimension" task and nvarchar(max)

Answer this question