SSIS-Slowly Changing dimension--Nvarchar(MAX) ISSUE

1
votes

I am getting a data conversion error when I try to load data from one SQL table to another SQL table, using SSIS.

The source table has a column with data type nvarchar(max). The destination table has the same data type. I keep getting conversion errors when I use the Slowly Changing Dimension component.

Error: " Input column "des" (116) has a long object data type of DT_TEXT, DT_NTEXT or DT_IMAGE which is not supported"

Please help

1
sql-serverssis
social.msdn.microsoft.com/Forums/sqlserver/en-US/… - S1r-Lanzelot
The SSIS SCD component is LAME. There are many reasons to not use it, and this is one of them. Are the tables on the same SQL Server? Solve your problem and get 100x speed increase by just writing a MERGE statement instead - Nick.McDermaid

1 Answers

0
votes

Use something else besides the Slowly Changing Dimension. You can't use that component with nvarchar(max).