SSIS XML Source String DataType Length Error

Question

I've a XML Source column "Comments" and data type is UniCode WSTR but in the source [UI] its capturing more than 4000 characters so SSIS ETL failed to load in destination table as the error shows "truncation of data length" & Destination column DataType is nVarchar(Max). Please suggest me how to load the data into destination.

Ferdipux · Accepted Answer · 2017-09-05 16:11:45Z

0

You could declare this column as an NTEXT. However, beware of two downsides of such step:

You have to check this definition every time you update XML datasource Yes, every time, because SSIS likes to reset string XML elements to its default - nvarchar(50).
Using NTEXT column has a negative performance impact, for details see https://stackoverflow.com/a/28507399

answered Sep 5, 2017 at 16:11

Ferdipux

5,2791 gold badge22 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS XML Source String DataType Length Error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related