SSIS Using XML Source and max size limit of nvarchar(4000)

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  June 19, 2013 at 8:43 am

  #275329

  I have xml files that I'm trying to import into SQL Server using SSIS XMLSource and the xml file has a field that contains more that 4000 bytes. I think the maximum is 4000. I'm defining this in the external and output column area of the XML Source Show Advance Source Editor. Any ideas how to get around this problem?

• ryanwooster1980

  SSC Enthusiast

  Points: 103

  More actions

  June 19, 2013 at 9:45 am

  #1625550

  what version of SQL Server are you using? for 2005+ you can use varchar(MAX) this goes a little further into it

  http://www.sqlservercentral.com/Forums/Topic647815-145-1.aspx