Max size in DataType Properties - Advanced Editor

• avishain

  Mr or Mrs. 500

  Points: 506

  More actions

  January 29, 2013 at 8:28 am

  #269836

  Hello there,

  ssis 2012.

  is there a way to make this column more than 4'000?

  the thing is, this field is Huge (contains text) and in my DB i set a filed with NVARCHAR(MAX)

  while trying to use DT_WSTR(MAX) in the advanced editor i got an error... so i used

  DT_WSTR(4000) but there are cases when truncation occurs and i loose some of the data.

  how can i remove the limitation of the 4,000?

  thanks

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 31, 2013 at 6:19 am

  #1582945

  Not sure if XML Source has some limits, but you could try setting the output column to DT_NTEXT.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato